Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count 2 nonblank cells on multiple worksheets April Excel Discussion (Misc queries) 1 April 18th 06 09:15 AM
Copy Worksheets from one Workbook to Another halem2 Excel Worksheet Functions 3 March 25th 06 07:04 AM
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row Sam via OfficeKB.com Excel Worksheet Functions 6 November 29th 05 04:27 PM
Count of Worksheets Terry Excel Discussion (Misc queries) 7 February 23rd 05 10:39 AM
How to count # of worksheets? Stephen POWELL Excel Discussion (Misc queries) 4 January 27th 05 03:05 PM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"