Nesting COUNTIF

A

Andrew K

In Excel 2003, is there a way to combine the functions COUNTIF(A1:A10,"Joe")
and COUNTIF(B1:B10,">5")? In other words, the array in Cols A and B has
scores from 0 to 10 for multiple trials by Joe, Bill, and Jane; I want a
count of all of Joe's scores that are over 5.
 
S

Sandy Mann

=SUMPRODUCT((A1:A10="Joe")*(B1:B10>5))

If you meant 5 or over then use >=5

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
A

Andrew K

Works perfectly. Thank you.

Sandy Mann said:
=SUMPRODUCT((A1:A10="Joe")*(B1:B10>5))

If you meant 5 or over then use >=5

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
S

Sandy Mann

You're very welcome. Thanks for the feedback.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top