Countif with AND function

[Sudarshan]

Hi
I am trying to do a countif with AND in criteria, below is the formula.

Countif(A:E,AND(Y4,Y5))

Can you please help me out what is wrong with the formula. I would like to know if there is any shorter way of doing this rather than multiple countif together.

Thanks
Sudarshan

 

[NARAYANK991]

Hi Sudarshan ,

Rather than ask others to debug a wrong formula , can you say what you wish to do ?

Narayan

 

[Sixthsense]

If your excel version is 2007 and above then use countifS()

If it is excel 2003 then check sumproduct()

 

[Xiq]

Your given array and formula makes me think you don't want an AND logic, but an OR logic ( Correct me if I'm wrong )... so count every cell that contains "Y4" + count every cell that contains "Y5". In that case, try this:

=countif(A:E,"Y4") + countif(A:E,"Y5")

(If the Y4 and Y5 are actually cell references, then remove the double quotes)

 

[Sixthsense]

Or

=SUM(COUNTIF(A:E,{"Y4","Y5"}))