| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Avoid counting Blank cells as "0"
Hi I am using following formula:
=SUMPRODUCT((import!$N$1:INDEX(import!$N$1:$N$3500 0;COUNT(import!$A$1:$A $35000))0)*(import!$N$1:INDEX(import!$N$1:$N$3500 0;COUNT(import!$A$1:$A $35000))<=3)) My problem is that 0 does not count cells with 0 but only larger than 0. If I change it to =0 it sees all blank cells within N1:N35000 as 0. How can I avoid this???? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200901/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to avoid "insert copied cells"? | Excel Discussion (Misc queries) | |||
| counting non blank cells for "sum(if" formula | Excel Worksheet Functions | |||
| In excel counting cells in a range which meet condition "Xand<X" | Excel Worksheet Functions | |||
| How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
