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