5 replies
by cyndeec
You can't use COUNTIF with multiple criteria. To solve that problem you need to use an array formula. Look up "examples of commonly used formulas in help" and check the section on "counting the occurrences of multiple conditions" The formula for your problem would be something like this (modified for your worksheet of course!)where the first range contains your first criteria, the second range your second criteria, and if it matches, a "1" is added to the sum, otherwise a "0" is added. This type of formula must be entered on the formula bar with CTRL+SHFT+ENTER.
=SUM(IF(B62:B67="North",IF(C62:C67="West",1,0)))
by snubber
You can use the COUNTIF feature as long as you have a value that is constant either positive or negative. If you wanted to count all people who were working/putting in hours between 10am and 12pm, you would like to count all non zero's. So, COUNTIF(insert the range of cells here,>0). This will return a count of all people who had put in at least one or any part of an hour during that time frame. Please advise of usability.
Thanks,
Steve
This discussion is closed to new replies.
Trending Software posts
Sort by Trending