Count/Calculation According to Age of the Person

N

Neon520

I'm making an attendance summary sheet. And here is what I want to do:

What can I do if I need to have some certain "letter" counted, or some
number calculated
depend upon the person age?

Let's say there are 6 different age group and I want to have a formula that
will pick up the attendance of Mr. A in a certain group depend upon his age,
and WHEN Mr. A's birth date is in the middle of the month, the formula will
automatically divide Mr. A's attendance into two different age groups
accordingly to the birth date as a cutoff date as well. Is it possible to do
this in Excel?

Other info:
I know how to count the attendance by using "if" and "counta" function to
pick up certain symbol to count the attendance.
And I found out of how to calculate the age of a person by
=INT((TODAY()-<person's birth date)/365.25).
 
C

CLR

This formula will count all the numbers in column A that are between 60 and
65 inclusive.

=COUNTIF(A:A,">=60")-COUNTIF(A:A,">65")

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accumulating Attendance Base upon Age Group 5
Calculating age from date of birth and ignoring if blank 5
"how do I calculate age by using date of birth details" 5
calculate date of birth with an end date and age 1
Determining the Age of a Person 3
Age calculation 4
Rule of 75 Retirement Calculation 27
Count a range that matches the heading 2

Top