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