Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting countif functions | Excel Worksheet Functions | |||
If and CountIF Nesting | Excel Worksheet Functions | |||
Nesting functions - Countif ... | Excel Worksheet Functions | |||
nesting with countif | Excel Discussion (Misc queries) | |||
Nesting formulae with COUNTIF | Excel Discussion (Misc queries) |