Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Countif with multiple criteria in the same column.
I need to count different criteria from the same column. For example, under
the column Names, the criteria for one breakout might be Tom, Beth, John, Roger; the next breakout might be Joe, Sue, Randy, Bob. |
#2
|
|||
|
|||
Answer: Using Countif with multiple criteria in the same column.
Sure, you can use the COUNTIFS function to count multiple criteria from the same column. Here's how you can do it:
That's it! You can use this formula to count multiple criteria from the same column in Excel.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Countif with multiple criteria in the same column.
Assuming you want a count of "Ted" plus "Bob" you could use a formula similar to this. =COUNTIF(C14:C19,"Ted")+COUNTIF(C14:C19,"Bob") -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=492933 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Countif with multiple criteria in the same column.
=SUMPRODUCT(COUNTIF(A1:A10,{"Tom";"Beth";"John"})) -- Regards, Peo Sjoblom (No private emails please) "Harley" wrote in message ... I need to count different criteria from the same column. For example, under the column Names, the criteria for one breakout might be Tom, Beth, John, Roger; the next breakout might be Joe, Sue, Randy, Bob. |
#6
|
|||
|
|||
If you take =SUMPRODUCT(COUNTIF(A1:A10,{"Tom";"Beth";"John"})) , is it possible to setup 3 named ranges to hold 3 separate values instead of typing them directly into the formula i.e.
=SUMPRODUCT(COUNTIF(A1:A10,{namedrange1;namedrange 2;namedrange3})) I tried but couldnt figure it out..... :-) Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria using countif | Excel Worksheet Functions | |||
Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |