Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple criteria/Countif question
How can I have multiple criteria counted in the same range? Specifically, I
am looking to count the total number of individuals who are working either 10 or 24 hours on a given day together in one cell. They are listed in coulmns that correspond to the days of the month. I also have people working 8 and 13 hours and have cells for those totals. For that I use countif(A1:25, "8") or similar for 13 but I cannot figure out how to add the 10 and 24's together. Any help is appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple criteria/Countif question
Hi edju,
=COUNTIF(A1:A25,10)+COUNTIF(A1:A25,24) Should do what you want unless I am missing something. HTH Martin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple criteria/Countif question
That did it thank you!
"MartinW" wrote: Hi edju, =COUNTIF(A1:A25,10)+COUNTIF(A1:A25,24) Should do what you want unless I am missing something. HTH Martin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple criteria/Countif question
Here's another way:
=SUM(COUNTIF(A1:A25,{10,24})) Biff "edju" wrote in message ... How can I have multiple criteria counted in the same range? Specifically, I am looking to count the total number of individuals who are working either 10 or 24 hours on a given day together in one cell. They are listed in coulmns that correspond to the days of the month. I also have people working 8 and 13 hours and have cells for those totals. For that I use countif(A1:25, "8") or similar for 13 but I cannot figure out how to add the 10 and 24's together. Any help is appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |