sumproduct--counting--zero--blank cells

[jeremy via OfficeKB.com]

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

 

[Guest]

COUNTBLANK(range)

 

[RagDyeR]

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))

--

HTH,

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

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

 

[jeremy via OfficeKB.com]

Thanks for all the help RagDyeR

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

 

[RagDyeR]

You're very welcome.