MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!!! :-)