You're very welcome.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"jeremy via OfficeKB.com" wrote in message
...
Thanks for all the help RagDyeR



RagDyeR wrote:
If you have zeroes, and you want to count them, try this:

=SUMPRODUCT(($W$9:$W$272=0)*($W$9:$W$272<"")*($ W$9:$W$272<10))

I'm using these formula to count,

=SUMPRODUCT(($W$9:$W$272=0)*($W$9:$W$272<10))
=SUMPRODUCT(($W$9:$W$272=10)*($W$9:$W$272<20))
.......etc
how do i get it so bank cells are excluded from the count. The way it is
now,
they are counted in the 0 to 10 range...

Thanks
Jeremy


--
Message posted via http://www.officekb.com