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