software

I need to count the number of times quot;Yquot; occurs on several worksheets. I keep
getting an error with COUNTIF. Help!
--
Thanks for your assistance!

Karen

Use

SUM(COUNTIF('Sheet1'!A1:A10,quot;Yquot;),COUNTIF('Sheet2 etc

adapt to fit accordingly

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Karenquot; gt; wrote in message
...
gt;I need to count the number of times quot;Yquot; occurs on several worksheets. I
gt;keep
gt; getting an error with COUNTIF. Help!
gt; --
gt; Thanks for your assistance!
gt;
gt; Karen
Thank you very much! Worked like a charm!!!
--
Thanks for your assistance!

Karenquot;Peo Sjoblomquot; wrote:

gt; Use
gt;
gt; SUM(COUNTIF('Sheet1'!A1:A10,quot;Yquot;),COUNTIF('Sheet2 etc
gt;
gt; adapt to fit accordingly
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Karenquot; gt; wrote in message
gt; ...
gt; gt;I need to count the number of times quot;Yquot; occurs on several worksheets. I
gt; gt;keep
gt; gt; getting an error with COUNTIF. Help!
gt; gt; --
gt; gt; Thanks for your assistance!
gt; gt;
gt; gt; Karen
gt;
gt;
gt;