Hi,

I have a workbook that contains 100 identical worksheets. I need to count
how many 1's are in say H1, how many 2's, etc.

Can anyone please help me with this? I read somewhere in the discussions
about having "dummy" sheets named Start and End and then just do a range.
Can someone remind me of that formula?

Thanks so much,
Michelle