| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting age groups
I having issues in picking up certain ages from the formula i am using. The
problem the formula is fine until it has to count the value showing within the formula. i.e if i have to count age 20 it doesn't seem to pick this up or with the age 18, but within the range there is no issue. The formula i am using is =SUM(COUNTIF(F27:F48,{"<18","<=20"})*{-1,1}). I have also tried to move the = sign with no effect. With each specific age range i am having the same problem. I hope some is able to help as it would most apprciated. Chedd -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting a single value across multiple cell groups | Excel Discussion (Misc queries) | |||
| Counting groups of exact numbers in a huge list (column) | Excel Discussion (Misc queries) | |||
| how do i view all groups under excel in google groups | Excel Discussion (Misc queries) | |||
| Counting groups of exact case numbers w/letters in them. | Excel Discussion (Misc queries) | |||
| Counting groups exact case numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
