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?