All Questions
100
questions
0
votes
3
answers
74
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
32
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
22
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
138
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
1
answer
118
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
181
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
122
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 ...
0
votes
2
answers
3k
views
COUNTIF using two conditions while ignoring duplicates
I am attempting to create a chart showing the number of BEV/HEV/ICE vehicles bought each year.
I know the formula must have two conditions, but I can't figure out how to get it to ignore duplicates or ...
-1
votes
1
answer
575
views
Excel: How to count how many times a consecutive text value appears
I'm making a work schedule and I have to pay attention to a specific rule that, no worker should be scheduled to work more than 6 days in a row.
I got this spreadsheet where I make those schedules but ...
4
votes
4
answers
596
views
How to evaluate multiple OR'd conditions in COUNTIFS (or similar) row-by-row?
Consider the following sample data.
A
B
1
2
8
4
2
1
3
7
4
8
Separately, the count of A that is less than 5 is =COUNTIF(A1:A5, "<5") -> 4, and that for B is =COUNTIF(B1:B5, "...
0
votes
1
answer
25
views
How do I count how many times this category appeared only if the value in the column name is not equals to "N/A"
I have these sample data:https://docs.google.com/spreadsheets/d/1TSpuMRktIRAoACH5s1Dk9189NsNpJwjRtNaR5QROZg8/edit?usp=sharing
I wanted to count how many times a certain category has appeared only if ...
0
votes
2
answers
170
views
COUNTIF with formula expression
I have a grid with header names in the first row and first column, e.g.:
A
B
C
D
A
B
C
D
The cells with the same header name in their row and column represent "valid" value for the ...
0
votes
1
answer
1k
views
Countif with literal array
Why does this formula not work: COUNTIF({1,2,3},2)?
I can use both COUNT() and COUNTIF() with a range, but I can replace the range with a literal array only on COUNT, not on COUNTIF.
If I use LET to ...
0
votes
3
answers
1k
views
Excel COUNTIFS where the condition is row-specific
I am trying to do a COUNTIF on the following data where the criteria is row specific and does not link to a specific value or cell.
For example, in the following example, I am trying to count the rows ...