Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif over several worksheets
I'd like to have a countif equation over the range Sheet1:AA2, Sheet2:AA2,
Sheet3:AA2 and I want it count anything that is not equal to 2. How would I write this. Thanks, Barb Reinhardt |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif over several worksheets
COUNTIF() does not work over dis-joint ranges.
Try: =(Sheet2!AA2<2)+(Sheet3!AA2<2)+(Sheet1!AA2<2) -- Gary's Student "Barb Reinhardt" wrote: I'd like to have a countif equation over the range Sheet1:AA2, Sheet2:AA2, Sheet3:AA2 and I want it count anything that is not equal to 2. How would I write this. Thanks, Barb Reinhardt |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif over several worksheets
=SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&{1,2,3}&"!AA2 "),"<2"))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Barb Reinhardt" wrote in message ... I'd like to have a countif equation over the range Sheet1:AA2, Sheet2:AA2, Sheet3:AA2 and I want it count anything that is not equal to 2. How would I write this. Thanks, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif function in multiple worksheets | New Users to Excel | |||
Help with countif on multiple worksheets | Excel Worksheet Functions | |||
countif across worksheets | Excel Worksheet Functions | |||
Countif multiple worksheets | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |