Thread
:
Nesting COUNTIF
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann