I am using Excel 2003 and I need to count how many times specific text
appears. Here's the catch ... my worksheet is set up as follows:

A - First Name
B - Last Name
C - Badge (ID)
D - Store No.
E - ScanDttm (work day)
F thru AB - [contain various formulas I used to calculate time punch info]
AC thru AK - [contain formulas I used with a TRUE/FALSE or n/a result to
determine if an individual worked certain hour thresholds during the day,
i.e. "MORE THAN 5 HRS.", "BETWEEN 5 & 5:15", 'MORE THAN 6 HRS", etc.]

For the purpose of attempting to count text occurances, I have created a
second copy of the worksheet where the TRUE/FALSE or n/a results are text and
not formulas - I hope that helps. My problem is adding up how many times
TRUE, FALSE & n/a appear for each individual because my data is set up where
each person has multiple rows of information depending upon the number of
days they worked (column E). My first person has data in rows 2 thru 13, the
next person has data in rows 14 thru 66, etc. It is different for each
person.

I have over 60 worksheets with an average 3500 rows of data that I need to
calculate. Yikes! Can someone help? Your assistance would be greatly
appreciated!

---
heyredone