=SUMPRODUCT((age_group_range=test_age_group)*(abse nce_range<"A")*(absence_range<"AE"))



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Neon520" wrote in message
...
Okay, now I know how to calculate a person age using datedif, but I need
to
know how to accumulate the attendance of a person.

I've set up 30 columns for a month and blank cell represent attending, "A"
as absent unexcused and "AE" as excused absent. Previously, I calculate
the
attendance by taking 30 minus the appearance of A, and AE, ( I used
countif
function to add up A and AE). But now that I have to categorize each
person's attendance by their age group, how can I ACCUMULATE each person
attendance?

WHAT IF, for example, one person birth date fall into the middle of the
month and need to move to the next age group, can Excel handle this type
of
variable situation?

Is there anyone interested in solving this problem?

Thanks a millions for any clue?

GU
P.S. I'm really frustrated!!!!