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.
202
questions
0
votes
3
answers
75
views
Functions based on multiple criteria
I want to do some count functions based on multiple criteria. I have a sample dataset here:
I want to find the number of Males if BD = MCD or FSGS.
For this I tried:
=COUNTIF(Gender,"M")+...
0
votes
1
answer
33
views
How to get total QTY from two columns, and get QTY based on location and date range
So I have been trying to get an answer to this situation and I have tried a slew of functions from countifs, sumifs and its not working as I had hoped.
What I am trying to do: I have two tabs in excel ...
1
vote
1
answer
24
views
How to get unique count of values within a specific date range avoiding duplicate values, for a specific location
I am attempting to obtain the sum of a column that has duplicate values, and have those duplicate values counted as 1 instance within a specific date range, that is representing the reporting week. So ...
1
vote
1
answer
141
views
How to get unique count of values within a specific date range avoiding duplicate values
I am attempting to obtain the sum of a column that has duplicate values, and have those duplicate values counted as 1 instance within a specific date range, that is representing the reporting week. So ...
0
votes
0
answers
18
views
CountIFs Beyond
I am trying to compile a summary sheet that takes the Employee Name from Row 5, summarizes how many red (2) or yellow (1) are in any given month.
I have figured out the COUNTIF for it as a whole, but ...
0
votes
1
answer
76
views
I want to use countif function to get the count of total devices on each ID i have applied the formula but no answer
I want to use COUNTIF() function to get the count of total devices on each ID i have applied the formula but no answer.
Refer to attach image for data.
0
votes
1
answer
18
views
Count number of times 2 words appear in cells
can someone help me. I am looking to count how many times 2 words appear in a column full of job titles. For example I want to know how many Programme Managers there are in column D. Job titles in ...
0
votes
0
answers
9
views
Subtract multiple cells if between date with Excel
Trying to subtract three cells (N1-P1-T1) when cell K1 is between two dates (">="&U2 and "<="&V2).
I can't seem to figure out how to subtract three cells when the ...
0
votes
1
answer
122
views
Excel: Using COUNTIF + UNIQUE gives generic error "There's a prblem with this formula"
I'm trying to create an excel function that counts the number of unique entries in a range of (potentially merged) cells. The UNIQUE function returns two values for merged cell, one of which is zero. ...
0
votes
2
answers
86
views
Counting the number of times a value appears in a range of columns
Consider the following table which shows a generalised, abstract version of my specific real-world problem (which I will also illustrate).
Each "1" or "0" is part of a column ...
0
votes
3
answers
190
views
In Excel, how do I count the number of rows in a table that pass a filter with AND and OR logic?
In Excel, I have data like this:
I want to put together a formula that counts the rows where Col1 is "a" or "b" and Col2 is "c" or "d". I highlighted the rows ...
0
votes
1
answer
73
views
Count the number of cells in an Excel range using multiple criteria with wildcards
With Excel, when using the COUNTIFS() function with a single criteria, a wildcard value works just fine. Using the example data below, the following functions work as expected with my interesting data....
0
votes
1
answer
82
views
COUNTIF is 0. Two values in the same column
It seems that my formula is not counting 2 different values in the same column. The only calculation that worked was one with identical values.
Can you share a method to associate multiple values to ...
0
votes
1
answer
26
views
Conditionally counting the total number of matching rows for different dates
I need to monitor the TOTAL number of active female visitors by date. Tried to generate a formula by myself but failed and now ask your help. Data are as follows:
For each date in column A, the ...
0
votes
1
answer
128
views
Counting number of cells between two variable in anywhere in list in sequence in excel
I am trying to build a formula in excel to pass two text values to match in a list and find number of cells between them. The count needs to go in sequence 1 to 27 and if one variable is at 27 row and ...