# Questions tagged [countif]

COUNTIF generally refers to a worksheet function within a spreadsheet program that counts cells in a range based on a specified condition. This tag can also be used for COUNTIFS, which provides a similar function but allows multiple ranges and criteria.

159
questions

**0**

votes

**0**answers

36 views

### I want to sum a unique value with specific data. Below is my explanation [closed]

Here is my data format
ColA ColB
Day Agent1
Day2 Agent1
Day2 Agent1
Day2 Agent1
Day3 Agent1
Day2 Agent2
Day2 Agent3
I want to sum a number of Agents of Day 2 without duplicate ...

**0**

votes

**0**answers

60 views

### One req to many candidates - Transposing data from one row to multiple rows based on # of positions

I am struggling with finding the right excel formula. Trying to avoid writing script in VBA as user will not be able to maintain it going forward and I found with formulas it is a bit easier. We have ...

**0**

votes

**2**answers

102 views

### Count first cells in a range of rows, which are higher than 0 and meet criteria

For each column, I would like to count the amount of cells, which are higher than 0, appear for the first time in the row, and meet a criteria in one of the columns.
In this example, I would like to ...

**0**

votes

**1**answer

51 views

### Inputting several values, found from a VLOOKUP function, into a COUNTIF function

This question is about a single function (in a single cell to later extrapolate over a whole table) in Microsoft Excel.
I want to find a unique id on another page (amongst other id's in the first ...

**1**

vote

**3**answers

31 views

### Counting unique values against a subset of a list

I'm trying to count how many unique supervisors a particulate employee has. (See an example data set below.)
I'm able to do this in a round about way, but I'm wondering if any of you experts out ...

**1**

vote

**1**answer

155 views

### SUMIF versus SUMIFS

SUMIF allows to sum using a single criteria, where SUMIFS works with multiple criteria.
I tend to find that on many occasions, I've start with SUMIF and then need to add more criteria, so change the ...

**0**

votes

**4**answers

38 views

### Need To Count Total Number Of Instances Of Values In A Column And Return The Results In Other Cells

I have a situation where I need to count the total number of instances of values in a column and return the results in other cells.
Users are going to be provided this Excel sheet as a template and ...

**0**

votes

**1**answer

34 views

### How to combine multiple COUNTIF in Excel?

I have this formula:
=OtherSheet!$B$2*COUNTIF(C6:CX6;OtherSheet!$A$2)
It looks in the columns to the right and for each occurrence of a string from the other sheet's A2 it adds the other sheet's B2.
...

**0**

votes

**1**answer

74 views

### Why does my Excel COUNTIF function always return a value of ā0ā?

My HTML is:
div class="medium-insert-images" data-media-id="47deed170ef76561" data-original-width="590" data-original-height="350" contenteditable="false"figure img src="https://cdn-blog.scorum....

**1**

vote

**1**answer

16 views

### Multiple values same line COUNTIF

I have a table as follows for a musical instrument casting sheet [titled Song Casting)
Here's an MWE:
+--------+------+--------+-------+------+--------+---------+
| Song | Bass | Guitar | Drums | ...

**0**

votes

**0**answers

28 views

### COUNTIFS with multiple criteria across multiple sheets

The data: by day, tracking whether multiple buses are in service or not and the brand of the bus (7 buses in question (each bus has it's own sheet); 2 brands, 2 statuses, all in separate columns in a ...

**0**

votes

**0**answers

156 views

### Trying to count correct answers quickly in Excel using ā>=1ā logic

Trying to count correct answers quickly, so I want to count if the cell is >=1. The answers are O (wrong) or 1 (correct).
=Countif(V2:FV2),">=1"

**0**

votes

**1**answer

35 views

### Counting the occurence of active durations by month and into a graph

Lets assume I currently have a spreadsheet that holds the dates of members at a crossfit gym and the duration of their memberships.
Date Started Date Ended Member Name
11/27/2019 12/19/2019 ...

**0**

votes

**0**answers

33 views

### Combining IF Statement with CountIF

I'm having trouble combining an IF Statement with a COUNTIF statement.
I have a list where I only want excel to count the cells if it has a value of greater than 0, i.e. if there is an inputted value....

**0**

votes

**1**answer

48 views

### Excel “IFS” criteria values using cell references

My data consists of a month column A (1 through 12) and a values column B (financial returns) spanning multiple years. How do I count the number of month occurrences in the second half of the year ...

**0**

votes

**2**answers

60 views

### How to COUNTIFS with OR and >= Operator logic

I've found threads that addressed OR logic or operator logic but none together and it's not working for me.
Let's say I have a table like this:
Col1 Col2(Date) Col3(Date)
I want to use ...

**0**

votes

**1**answer

183 views

### How to count distinct values in one column for each distinct value in another column in MS Excel?

Say I have the following data in an Excel sheet:
Country Fruit
USA Banana
USA Apple
USA Apple
USA Orange
USA Banana
USA Apple
UK Banana
UK Banana
UK Apple
I ...

**0**

votes

**3**answers

64 views

### Excel - Indirect Formula

another question regarding Excel Indirect Formula.
I have columns E1:J202 filled with one of the following:
Green
Amber
Red
How can I use the indirect formula to count each of the above separately ...

**0**

votes

**1**answer

30 views

### Count of number of times a max of the dates in two columns is bigger than the date in the third column

I have three columns in a report: a closure date (Col A), an implementation date (Col B) and a target date (Col C).
I need to count the number of times an entry is closed or implemented before the ...

**1**

vote

**2**answers

50 views

### Countif Date Array Formula

I'm trying to build a sheet for tracking compliance with training. I'm needing to build some summary fields, which show how many procedures a person is current on, how many they are out of date with, ...

**0**

votes

**3**answers

395 views

### Count cells in a column between values until specific value reached in Excel

I am trying to count cells from a column between two values:
I have a list which on the range A2:A118. I want to start counting when a specific value is reached and stop when another specific value is ...

**0**

votes

**1**answer

31 views

### Finding Unique Values across many columns

I'm working on what I thought would be a simple task that has become quite complicated.
In Column A, I have a Field Name. In columns B through ANV (1059 columns) I have values associated with that ...

**0**

votes

**2**answers

30 views

### Count number of rows that have X in cell A or B or C

I think looking at the photo is the easiest way to show what I need:
Original Table
How do I set up a single formula to count the number of kids who failed an exam section?
What I've managed so ...

**0**

votes

**0**answers

18 views

### Counting blanks or not blank cells in 1 columnmatching criteria in a 2nd

I have a list of trouble tickets with groups in one column and assignee names in another -- if someone is assigned. If no one is assigned, the cell is blank. For each group, I want to count the ...

**1**

vote

**2**answers

112 views

### Count how many times string is contained within string within a range in excel

I would like to parse through URLs and count how many times a string e.g. 'apple' occurs within a range. I tried =COUNTIF but it's looking for exact matches.
I have about 80k rows of URLs and I need ...

**0**

votes

**1**answer

65 views

### Count If Formula for 2 Separate Criteria

I am trying to write a CountIf Excel formula for 2 separate criteria on the same range. The range consists of a formula that generates a 1 or 2, so the Countif formula tells the user what category ...

**0**

votes

**2**answers

66 views

### Excel - keep the absolute reference from inserting row using COUNTIFS function

How can I use the absolute reference Column in a different sheet in COUNTIFS function?
COUNTIFS(Scenario!C:C,C21,Scenario!H:H,"PASS")
We are inserting new column on H, and then the reference range ...

**1**

vote

**1**answer

59 views

### Sum the Count of Min of each column by row

I am trying to automate a spreadsheet that will keep a running tally of the most negative topics week over week (kind of like Billboard top 100).
I have tried to get Column A(No.1) to calculate the ...

**0**

votes

**2**answers

273 views

### COUNTIFS when criteria has more than 255 characters

I was looking for a formula in Excel that will search into different ranges parts of text that meet another criteria. So, basicalLy it is a COUNTIFS. While trying to use the formula, which perfectly ...

**0**

votes

**0**answers

25 views

### COUNTIF when wanting a result between certain dates

So I'm in a little bit of a quandary. I'm creating a KPI dashboard, and one of those is the number of meetings booked and then number of meetings sat.
I'm creating a weekly dashboard that is ...

**0**

votes

**2**answers

58 views

### Count If: Using Formula to Create Range

I am trying to create the Range of a CountIf formula, using formulas. I found some data on using INDIRECT, but it doesn't seem to fit the bill. Here is the specific problem:
SHEET 1:
A B ...

**0**

votes

**1**answer

70 views

### Count number of rows matching multiple criteria

I'm working with two Excel workbooks. The first one contains this table:
The other contains this one:
Is it possible with VBA, for each week, to count the number of rows matching three specific ...

**1**

vote

**1**answer

49 views

### Cross table of joint games

I have a list of games of badminton that have been played over a period of time:
Each row contains the game id and one player id. Each game was played with four players. So, for each game there are ...

**0**

votes

**2**answers

3k views

### Simple regex with Excel COUNTIF to match a substring?

How do I fix this formula: =COUNTIF(A1:A10,"*jim*") to match anything containing the sub-string of "jim" but from a cell, as: =COUNTIF(A1:A10,C11) where cell C11 contains the text "jim"?
Perhaps ...

**0**

votes

**1**answer

125 views

### how to pass a string value into COUNTIF?

For this formula:
=COUNTIF(A1:A10,"jim")
how can I pass in a variable? That is, let's say that cell C11 has the value "jim"; can I then do something like:
=COUNTIF(A1:A10,TEXT_VALUE_OF_CELL(C11)) ...

**1**

vote

**1**answer

447 views

### How to use Excel to calculate concurrent streaks

I want to use Excel to calculate the "best" and "current" streak in a range of data.
Say that a shop's sales target for the day is 500. I have a column which contains the daily sales data for the ...

**0**

votes

**2**answers

171 views

### Excel ā using multiple criteria in COUNTIFS function

I need to create a formula that counts the number of times there is an overdue date in column I, where the corresponding cell in column J is blank.
I enter a date in column H (date appointed). There ...

**0**

votes

**1**answer

45 views

### How to properly use COUNTIFS with a defined named range?

I have a formula that counts the number of contact attempts for each month. The problem I am facing is that the formula only goes up to row 2000. How can I rewrite my formula to adjust with newly ...

**0**

votes

**1**answer

300 views

### Trying to use the value of a cell for criteria in COUNTIF

I've constructed a gradebook in LibreOffice Calc, and I'm trying to keep track of how many students have scored an A, B, etc., on assignments. Currently, I have the grades for an assignment in a ...

**-1**

votes

**1**answer

39 views

### Using COUNTIFS function with criteria if a value is in range of values

I need help with COUNTIFS function.
There are values in column B: a,b,c,d,e,f,....
I want to use COUNTIFS function to count items in column A, if the values in column B is included in range {a,c,f}

**0**

votes

**1**answer

46 views

### How can I count the number of occurrences in a range of cells?

I am looking to count the number of times a value is found in a range of cells between two dates. My range is not a table but has headers for "Date", "Time" and "Result". It stretches from $G8:KT$992. ...

**0**

votes

**1**answer

168 views

### Add a CountIF to a SumProduct Formula

In a previous question, Scott gave me this great formula to sum all the sales from salespeople who saw an increase in sales from 2017 to 2018:
=SUMPRODUCT(C2:C9-B2:B9, --(C2:C9>B2:B9), --(B2:B9>...

**2**

votes

**3**answers

75 views

### How to count cells if it contains a value in Excel

I have an Excel sheet like this:
ID | Relations
----+----------------
1 | ,
2 | ,
3 | ,1,
4 | ,1,2,
5 | ,2,
6 | ,3,
7 | ,1,2,4,
8 | ,1,2,4,5,6,
9 | ,2,4,5,1,
I want to count ...

**0**

votes

**0**answers

37 views

### Using COUNTIFS to count times within next 6 hours, next 12 hours, etc

I currently have COUNTIFS set up to count times in specific 6 hour time frames, for instance 12:00-18:00, but would like to change it to 6 hour increments FROM the CURRENT time: 6, 12, 18, and 24.
...

**1**

vote

**1**answer

152 views

### Count multiple letters in different cells

I'm looking for a formula that can count different letters included in different cells.
Example:
Cell A2 includes a letter "S"
Cell A3 includes a letter "F"
Cell A4 includes a letter "N"
Cell A5 ...

**1**

vote

**1**answer

32 views

### Excel: Using COUNTIF but not including blanks with other formulas

Firstly, apologies if this is covered somewhere deep within the site, I have looked through a lot of other posts and none of the solutions have worked for me.
I'm creating a workbook for a local ...

**1**

vote

**2**answers

80 views

### Count appearances of two-adjacent-cell value in range (Excel)

I am working on a sports analytics tracker in Excel, and for one part I need to count (I know there are other questions that just need to find them) how many appearances there are of a two-cell value ...

**0**

votes

**1**answer

88 views

### Countif for Dates

I need a formula for excel that says to countif (G3 >= BK (which is a date) and < BL3 (which is another date.
Countif the cell is equal to or greater than a cell, but less than another date(trying ...

**0**

votes

**0**answers

40 views

### Complex if then arguments in Excel

I have a calendar of months with time off codes on certain days an employee took off and has scheduled off. Codes are "V" for vacation, "PTO" for Paid Time Off, etc.
I am trying to input a formula ...

**0**

votes

**1**answer

41 views

### how to use Countifs function Excel?

from what i have been reading online it appears Countifs function is what i need to use for my problem. I have data that looks like this and goes on for several months:
|Month |Day| Time ...