sumproduct--counting--zero--blank cells

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

COUNTBLANK(range)

"jeremy via OfficeKB.com" wrote:

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

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!
=====================================================

"jeremy via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
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

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

You're very welcome.
--

Regards,

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

"jeremy via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
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