asked on COUNTIFS Function not adding multiple results
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
=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
Microsoft ApplicationsMicrosoft OfficeMicrosoft Excel
Last Comment
Steve
ASKER
Thank you. The help file is missing that statement.
Can you look at my second question..I edited it most likely as you were answering.
Can you look at my second question..I edited it most likely as you were answering.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
To count all that begins with i* or p*
To count all that does not begin with i* or p*
=COUNTIF(J6:AM6,"i*")+COUNTIF(J6:AM6,"P*")
To count all that does not begin with i* or p*
=COUNTIFS(J6:AM6,"<>i*",J6:AM6,"<>P*")
ASKER
Great explanation.
Glad to help!
you can use SUM(COUNTIF(J6:AM6,{"I*","
then you can put multiple criteria in between the {}.
then you can put multiple criteria in between the {}.
=COUNTIF(J6:AM6,"I*")+COUN