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