| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count occurances of years between two year brackets eg >24 & <50
Could anybody try to help with a calculation. I have calculated ages with
column formatted to yy =IF(ISBLANK(L28),"",($IV$65536-L28) - '$IV$65536 being Now()+2 With the column being formatted to yy, I cannot use the COUNTIF function to calculate the occurances of ages - I think this is because it is not a number Could anybody please make suggestions on how to format the cells to enable the use of a similar if not the COUNTIF function PS I can get COUNTIF to work when the age is manually input, but not calculated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of months year to date | Excel Worksheet Functions | |||
| count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
| Get count of records for a particular month and year | Excel Discussion (Misc queries) | |||
| Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
| Count occurances of multiple values | Excel Worksheet Functions | |||
Threaded Mode
