Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic coloring of blank cells when sheet work complete | Excel Worksheet Functions | |||
trimming blank cells | Excel Worksheet Functions | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
complex fomula: counting cells that are blank | Excel Worksheet Functions |