Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count from several worksheets
I need to count the number of times "Y" occurs on several worksheets. I keep
getting an error with COUNTIF. Help! -- Thanks for your assistance! Karen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count from several worksheets
Use
SUM(COUNTIF('Sheet1'!A1:A10,"Y"),COUNTIF('Sheet2 etc adapt to fit accordingly -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Karen" wrote in message ... I need to count the number of times "Y" occurs on several worksheets. I keep getting an error with COUNTIF. Help! -- Thanks for your assistance! Karen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count from several worksheets
Thank you very much! Worked like a charm!!!
-- Thanks for your assistance! Karen "Peo Sjoblom" wrote: Use SUM(COUNTIF('Sheet1'!A1:A10,"Y"),COUNTIF('Sheet2 etc adapt to fit accordingly -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Karen" wrote in message ... I need to count the number of times "Y" occurs on several worksheets. I keep getting an error with COUNTIF. Help! -- Thanks for your assistance! Karen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count of Worksheets | Excel Discussion (Misc queries) | |||
How to count # of worksheets? | Excel Discussion (Misc queries) |