The formula is working fine with integer values (18, 19, 20, etc).
That suggests a data issue. What values are contained in F27:F48?

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:78caad219710a@uwe...
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