count from several worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to count the number of times "Y" occurs on several worksheets. I keep
getting an error with COUNTIF. Help!
 
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
 
Thank you very much! Worked like a charm!!!
--
Thanks for your assistance!

Karen


Peo Sjoblom said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF across worksheets 3
need help on either doing a loop and counting specific values orusing subtotal function 2
Counting cells in a selectable date range 0
Excel Count If Formula Question 1
Count rows based on multiple criteria 3
Countifs for multiple worksheets 4
Possible to refer to a sheet's object name ? 1
sumif? countif? 3

Back
Top