| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem getting values
How can I calculate ages for example I have colums with ages and I need to
know how many people between of age of 20 to 30? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem getting values
=SUMPRODUCT((A1:A100=20)*(A1:A100<=30))
"Excel worksheet funtions" skrev: How can I calculate ages for example I have colums with ages and I need to know how many people between of age of 20 to 30? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem getting values
Do you mean =20 but <= 30?
Try one of these: =COUNTIF(A1:A10,"=20")-COUNTIF(A1:A10,"30") =INDEX(FREQUENCY(A1:A10,{20,30}-{1,0}),2) =SUMPRODUCT(--(A1:A10=20),--(A1:A10<=30)) -- Biff Microsoft Excel MVP "Excel worksheet funtions" <Excel worksheet wrote in message ... How can I calculate ages for example I have colums with ages and I need to know how many people between of age of 20 to 30? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with getting numbers in some range values!? | Excel Worksheet Functions | |||
| CountIf & null values problem | Excel Worksheet Functions | |||
| Problem with adding time values | Excel Worksheet Functions | |||
| Problem with % Values | Excel Discussion (Misc queries) | |||
| Problem with updating values with INDIRECT.EXT | Excel Worksheet Functions | |||
Linear Mode
