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