| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct thru blank cells
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct thru blank cells
Harsh,
pls be reminded that you have not yet closed questioned subject:*SUMPRODUCT NON-CONTINOUS CELL* 3/3/09. -- regards "Harsh Bahal" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct thru blank cells
"Harsh Bahal" wrote:
What should be the formula to enter a sumproduct formula which can ignore blank cells or cells with nil values in the identified range ? Do you really need to ignore those cells? Or is it sufficient to treat them as zero? If the latter, then apply this paradigm: =sumproduct(n(A1:A10)) Of course, if your SUMPRODUCT formula were that simple, you would simply use SUM(A1:A10). I have three set of range. A specific example would be helpful, to say the least. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct thru blank cells
Hi Driller, You are right , I have not recd any notification for the same. "driller" wrote: Harsh, pls be reminded that you have not yet closed questioned subject:*SUMPRODUCT NON-CONTINOUS CELL* 3/3/09. -- regards "Harsh Bahal" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct thru blank cells
I will get back directly to you.
" wrote: "Harsh Bahal" wrote: What should be the formula to enter a sumproduct formula which can ignore blank cells or cells with nil values in the identified range ? Do you really need to ignore those cells? Or is it sufficient to treat them as zero? If the latter, then apply this paradigm: =sumproduct(n(A1:A10)) Of course, if your SUMPRODUCT formula were that simple, you would simply use SUM(A1:A10). I have three set of range. A specific example would be helpful, to say the least. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
