I am trying to extrapolate an age range (i.e. 20-29) using information contained with in the same columns but on different sheets.  I tried to find the value of age 20 on a single sheet using the formula =COUNTIF(ACTIVE!N:N, “20”), but the value is clearly incorrect.  By looking at the column on just the one sheet, there should have been “0” age 20, but it gave me “28” .  There are 27 entries in that column of ages ranging from 24-92.

suggestions?

​I am trying to extrapolate an age range (i.e. 20-29) using information contained with in the same columns but on different sheets.  I tried to find the value of age 20 on a single sheet using the formula =COUNTIF(ACTIVE!N:N, “20”), but the value is clearly incorrect.  By looking at the column on just the one sheet, there should have been “0” age 20, but it gave me “28” .  There are 27 entries in that column of ages ranging from 24-92. suggestions?  Read More

​