# Multiple countifs

Options
✭✭✭✭✭

Hi,

I tried using =COUNTIFS(1st criteria range, 1st criteria, 2nd criteria range, 2nd criteria,3rd criteria range, 3rd criteria).

It is giving "0" in the result, can anyone help on this?

• ✭✭✭✭✭✭
Options

Hi @Prajna J

Hope you are fine, please find in the following sample to explain your question

in this sample, i need to count how many (A,Bus,Red)

the formula =COUNTIFS([criteria1]:[criteria1], "A", [criteria2]:[criteria2], "Bus", [criteria3]:[criteria3], "Red")

and the result = 3

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Hi Prajna

If you've set up your formula using @Bassam.M Khalil excellent advice and you're still returning a zero, eliminate all but one term in your COUNTIFS. Then systematically add the terms in one by one to try to pinpoint which term(s) is giving you the problem. Note: You don't have to change to a COUNTIF (singular) if you edit down to only one criteria - the great thing of COUNTIFS (plural) is it can be used all the time regardless of the number of criteria.

If you still experience problems, provide a screenshot (omitting any sensitive info) and the formula and the community can help you troubleshoot.

• ✭✭✭✭✭✭
Options

Hi @Prajna J

Hope you are fine, please find in the following sample to explain your question

in this sample, i need to count how many (A,Bus,Red)

the formula =COUNTIFS([criteria1]:[criteria1], "A", [criteria2]:[criteria2], "Bus", [criteria3]:[criteria3], "Red")

and the result = 3

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Hi Prajna

If you've set up your formula using @Bassam.M Khalil excellent advice and you're still returning a zero, eliminate all but one term in your COUNTIFS. Then systematically add the terms in one by one to try to pinpoint which term(s) is giving you the problem. Note: You don't have to change to a COUNTIF (singular) if you edit down to only one criteria - the great thing of COUNTIFS (plural) is it can be used all the time regardless of the number of criteria.

If you still experience problems, provide a screenshot (omitting any sensitive info) and the formula and the community can help you troubleshoot.

• ✭✭✭✭✭
Options

Thanks a lot!!

• ✭✭✭✭✭✭
Options

Hi @KDM