| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO SUM ALL 1 YR OLDS, SUM ALL 2 YR OLDS FROM a LIST OF DOB's
I have a list of birthdates on and excel spreadsheet. I can calculate their
ages in days, but how can I find out how many of these kids are 1, 2, 3, 4, and 5 years old? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW TO SUM ALL 1 YR OLDS, SUM ALL 2 YR OLDS FROM a LIST OF DOB's
if you dates are in column A from A1 to A100, then in B1 enter:
=DATEDIF(A1,TODAY(),"y") and copy down Then =COUNTIF(B1:B100,1) will be the number of 1 yearolds Then =COUNTIF(B1:B100,2) will be the number of 2 yearolds Then =COUNTIF(B1:B100,3) will be the number of 3 yearolds Then =COUNTIF(B1:B100,4) will be the number of 4 yearolds -- Gary''s Student - gsnu200720 "fairly new to excel" wrote: I have a list of birthdates on and excel spreadsheet. I can calculate their ages in days, but how can I find out how many of these kids are 1, 2, 3, 4, and 5 years old? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW TO SUM ALL 1 YR OLDS, SUM ALL 2 YR OLDS FROM a LIST OF DOB's
=SUMPRODUCT(--(DATEDIF(A1:A100,TODAY(),"Y")=1))
"fairly new to excel" wrote: I have a list of birthdates on and excel spreadsheet. I can calculate their ages in days, but how can I find out how many of these kids are 1, 2, 3, 4, and 5 years old? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Hybrid Mode
