I think I need an Array to get what I want, but I'm not sure how to write it.
I get part way then am at a loss. Worksheet is formatted as:

A: First Name
B: Last Name
C: Badge #
D-Z: [dates & hours worked calculations]
AA: MORE THAN 5 HRS (with IF calculations resulting in "1" for true or "0"
for false)
AB: LESS THAN 10 HRS (with IF calculations resulting in "1" for true or "0"
for false)
AC to AI: (similar hours increments)

Employee #1 has 8 rows of data due to the dates he worked (A2:A9), employee
#2 has 21 rows of data (A10:A30), employee #3 (A31:A 111)

I need to count how many times "1" appears in AA2:AA9 for employee #1,
number of times "1" appears in AA10:AA30 for employee #2, etc.

Is it an Array that I really need or something else? Thanks for any help
one can provide.
--
heyredone