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. |
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. |
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 |
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. |
Thanks for these posts. They were very helpful
|
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:
|
All times are GMT +1. The time now is 06:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com