COUNTIFS Function not adding multiple results
Posted on 2013-01-07
I am trying to use the COUNTIFS to state multiple criteria within a range to count. Can someone look at the attached example and tell me what might be wrong with my formula> I assume that
is going to count all cells in a range begining with I or P.
Additionally, can the Count functions be used to determine what does not meet a criteria such as... count everything in range J6:AM6 except "I*" and "P*"