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
=COUNTIFS(J6:AM6,"I*", J6:AM6,"P*")
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*"
Thanks,
MC
=COUNTIF(J6:AM6,"I*")+COUN