Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What should be the formula to enter a sumproduct formula which can ignore
blank cells or cells with nil values in the identified range ? I have three set of range. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to ignore blank date cells in sumproduct | Excel Discussion (Misc queries) | |||
=SUMPRODUCT formula is counting the blank cells as well as zero's | Excel Worksheet Functions | |||
=SUMPRODUCT formula is counting the blank cells as well as zero's | Excel Worksheet Functions | |||
sumproduct with 0/blank cells | Excel Worksheet Functions | |||
sumproduct--counting--zero--blank cells | Excel Discussion (Misc queries) |