Count function frustration
Posted by Shalimar on April 05, 2001 6:27 AM
I have a workbook with 43 tabs. One of the worksheets is a summary sheet accumulating (summing and averaging) data from the other 42. I want to count the number of occurances of data in a specific cell on each worksheet. For instance, if there is an entry of any kind in cell D10 on any worksheet, I want to know the total number of entries for my summary worksheet.
I can make the count functions work in a range on one worksheet but not on multiple worksheets in a workbook.
What am I missing?
Posted by Mark w. on April 05, 2001 6:45 AM
If you want to count the contents of cell A1 on
each of 3 sheets use:
=COUNT(Sheet1:Sheet3!A1)
Posted by Mark W. on April 05, 2001 6:55 AM
By the way...
If you're interested in counting both numbers and
text values use:
=COUNTA(Sheet1:Sheet3!A1)
Posted by Shalimar on April 05, 2001 8:17 AM
Re: By the way...
Wow, so simple...the range is the sheets *banging head* Couldn't see the forest for the trees.
Thank you so much!!! :-)
