Countifs within range

[coolzero]

Hello Guys,

Can you help me in having formula to count between ranges A:E with specific criteria?

I need to count how many are not blank from A:E columns with criteria of "David".


Thanks!

[Søren Larsen]

Perhaps:

=COUNTIF(A:E,"David")

?

[coolzero]

Sorry to confuse you. I have additional criteria, i need to count all non blank cells within B:E that are also within the criteria of "David" in column A.

[CheshireCat]

Try this:

=SUMPRODUCT((A2:A10="David")*(IF(B2:E10<>"",TRUE)))

Confirmed as an array formula with Ctrl-Shift-Enter.

[Ace_XL]

How about..

=SUMPRODUCT((B:E<>"")*(A:A="David"))

[coolzero]

Thank you!!!