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:

Please Login or Register  to view this content.

?

[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:

Please Login or Register  to view this content.

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

[Ace_XL]

How about..

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

[coolzero]

Thank you!!!