imback2nite
Board Regular
- Joined
- Oct 30, 2004
- Messages
- 203
- Office Version
- 2003 or older
- Platform
- Windows
Thank you in advance for looking at this!
I'm using this formula to count how many times cell H3 value appears in a range. I'm using Excel 2003 so COUNTIFS is not an option.
=COUNTIF($B$12:$AS$86,$H3)
There are 30 pages I would like this to evaluate. They are Sheet13 to Sheet42.
Is there a way to do this? Right now I'm using
=COUNTIF($B$12:$AS$86,$H3)
on the individual pages.
I'm using this formula to count how many times cell H3 value appears in a range. I'm using Excel 2003 so COUNTIFS is not an option.
=COUNTIF($B$12:$AS$86,$H3)
There are 30 pages I would like this to evaluate. They are Sheet13 to Sheet42.
Is there a way to do this? Right now I'm using
=COUNTIF($B$12:$AS$86,$H3)
on the individual pages.