Nesting COUNTIF

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

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Andrew K]

Works perfectly. Thank you.

=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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're very welcome. Thanks for the feedback.

--

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk