Nesting COUNTIF
 

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.

Nesting COUNTIF
 

=SUMPRODUCT((A1:A10="Joe")*(B1:B105))

If you meant 5 or over then use =5

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Andrew K" wrote in message
...
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.

Nesting COUNTIF
 

Works perfectly. Thank you.

"Sandy Mann" wrote:

=SUMPRODUCT((A1:A10="Joe")*(B1:B105))

If you meant 5 or over then use =5

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Andrew K" wrote in message
...
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.

Nesting COUNTIF
 

You're very welcome. Thanks for the feedback.

--

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


Replace @mailinator.com with @tiscali.co.uk


"Andrew K" wrote in message
...
Works perfectly. Thank you.

"Sandy Mann" wrote:

=SUMPRODUCT((A1:A10="Joe")*(B1:B105))

If you meant 5 or over then use =5

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Andrew K" wrote in message
...
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.