| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count number of childre between ages 0-5,6-10, 11-15
I need a formula that will help me count the number of children who are 0-5
years old and 6-10 years old ect. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count number of childre between ages 0-5,6-10, 11-15
Jessica,
2 options. Bring them round to my office and we'll count them together or explain the data layout in your worksheet:) Mike "Jessica" wrote: I need a formula that will help me count the number of children who are 0-5 years old and 6-10 years old ect. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count number of childre between ages 0-5,6-10, 11-15
Assuming you have a list of the children in one column and there ages in
another A1 Jessica Lang B1 7 A 2 Bonnie Lang B2 11 Ac Joan Rivers B3 4 IN a Suitable Cell D1 =Countif(B1:b3,<5) will give you under 5 "Jessica" wrote: =Countif(B1:b3,<5)-D1 WILL GIVE YOU UNDER 10 I need a formula that will help me count the number of children who are 0-5 years old and 6-10 years old ect. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count number of childre between ages 0-5,6-10, 11-15
Stew: I think your second formula should be =CountIf(B1:B3, <10)-D1
Jessica: If your spreadsheet contains dates of birth rather than ages in Col. B (which it should, so you don't have to update at each client's birthday), then calculate age as follows: =DATEDIF(B1, TODAY(), "Y") -- TedMi "stew" wrote: Assuming you have a list of the children in one column and there ages in another A1 Jessica Lang B1 7 A 2 Bonnie Lang B2 11 Ac Joan Rivers B3 4 IN a Suitable Cell D1 =Countif(B1:b3,<5) will give you under 5 "Jessica" wrote: =Countif(B1:b3,<5)-D1 WILL GIVE YOU UNDER 10 I need a formula that will help me count the number of children who are 0-5 years old and 6-10 years old ect. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count number of childre between ages 0-5,6-10, 11-15
THANK YOU tedmi YOU ARE CORRECT
BEST STEW "tedmi" wrote: Stew: I think your second formula should be =CountIf(B1:B3, <10)-D1 Jessica: If your spreadsheet contains dates of birth rather than ages in Col. B (which it should, so you don't have to update at each client's birthday), then calculate age as follows: =DATEDIF(B1, TODAY(), "Y") -- TedMi "stew" wrote: Assuming you have a list of the children in one column and there ages in another A1 Jessica Lang B1 7 A 2 Bonnie Lang B2 11 Ac Joan Rivers B3 4 IN a Suitable Cell D1 =Countif(B1:b3,<5) will give you under 5 "Jessica" wrote: =Countif(B1:b3,<5)-D1 WILL GIVE YOU UNDER 10 I need a formula that will help me count the number of children who are 0-5 years old and 6-10 years old ect. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing count of age to a group of ages | Excel Worksheet Functions | |||
| Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| CountIF columnH2-H101 the number of time between ages 20-29 occurs | Excel Worksheet Functions | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
Linear Mode
