| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
I need to a formula to calculate how many children from ages 3-12 i have in a
colum? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
What data is the column? Just Ages or Dates of Birth?
"Jessica" wrote: I need to a formula to calculate how many children from ages 3-12 i have in a colum? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
Just ages
"Toppers" wrote: What data is the column? Just Ages or Dates of Birth? "Jessica" wrote: I need to a formula to calculate how many children from ages 3-12 i have in a colum? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
=COUNTIF(A:A,"="&3)-COUNTIF(A:A,""&12)
Adjust the and = as appropriate, depending on whether the range should include or exclude those whose ages are equal to 3 or equal to 12. -- David Biddulph "Jessica" wrote in message ... Just ages "Toppers" wrote: What data is the column? Just Ages or Dates of Birth? "Jessica" wrote: I need to a formula to calculate how many children from ages 3-12 i have in a colum? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
Assuming ages in column a, try:-
=COUNTIF(A1:A30,"=3")-COUNTIF(A1:A30,"12") Mike "Jessica" wrote: Just ages "Toppers" wrote: What data is the column? Just Ages or Dates of Birth? "Jessica" wrote: I need to a formula to calculate how many children from ages 3-12 i have in a colum? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
Try to Filter the data on the age
Use Customs Greater than 3 and less than 12 You will be able to view all details of children under this category If you want to know how many then Mike's CountIF formula stands good "Mike H" wrote: Assuming ages in column a, try:- =COUNTIF(A1:A30,"=3")-COUNTIF(A1:A30,"12") Mike "Jessica" wrote: Just ages "Toppers" wrote: What data is the column? Just Ages or Dates of Birth? "Jessica" wrote: I need to a formula to calculate how many children from ages 3-12 i have in a colum? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| Help with Formulas | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
