| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count the number between age ranges
I have a spreadsheet (Replies) which contains ages in column C. I want to be
able to count all those who fall between certain bands/groups i.e. 25 - 34. I have tried to use the following: =COUNTIF(Replies!C5:C100,"=25")-COUNTIF(Replies!C5:C100,"<=34") which I have obtained and modified from othert threads, but I don't get the answers I expect. Any help would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the number between age ranges
Nigel < should be for the subtraction bit
=COUNTIF(Replies!C5:C100,"=25")-COUNTIF(Replies!C5:C100,"=34") Mike "Nigel" wrote: I have a spreadsheet (Replies) which contains ages in column C. I want to be able to count all those who fall between certain bands/groups i.e. 25 - 34. I have tried to use the following: =COUNTIF(Replies!C5:C100,"=25")-COUNTIF(Replies!C5:C100,"<=34") which I have obtained and modified from othert threads, but I don't get the answers I expect. Any help would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the number between age ranges
Mike
Many thanks for your reply, I see what I have done wrong, just the swapping of the greater and less than signs. Much appreciated "Mike H" wrote: Nigel < should be for the subtraction bit =COUNTIF(Replies!C5:C100,"=25")-COUNTIF(Replies!C5:C100,"=34") Mike "Nigel" wrote: I have a spreadsheet (Replies) which contains ages in column C. I want to be able to count all those who fall between certain bands/groups i.e. 25 - 34. I have tried to use the following: =COUNTIF(Replies!C5:C100,"=25")-COUNTIF(Replies!C5:C100,"<=34") which I have obtained and modified from othert threads, but I don't get the answers I expect. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup one value and count in two ranges | Excel Discussion (Misc queries) | |||
| Count age ranges | Excel Worksheet Functions | |||
| How can I count the number of ranges in a worksheet consolidation | Excel Worksheet Functions | |||
| count age ranges | Excel Discussion (Misc queries) | |||
| count if in two ranges | Excel Discussion (Misc queries) | |||
Hybrid Mode
