Fantastic and thank you for sparing the time to help.

Ron Coderre wrote:
Try something like this:

For 18 through 21
=SUM(COUNTIF(A:A,{"<18","<=21"})*{-1,1})

For 22 through 31
=SUM(COUNTIF(A:A,{"<22","<=31"})*{-1,1})

For 32 through 41
=SUM(COUNTIF(A:A,{"<32","<=41"})*{-1,1})
etc.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

Hi

[quoted text clipped - 17 lines]

Your help would be most appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200706/1