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.

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.

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.

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.

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.