Sumproduct thru blank cells

[Harsh Bahal]

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.

 

[driller]

Harsh,

pls be reminded that you have not yet closed questioned subject:*SUMPRODUCT
NON-CONTINOUS CELL* 3/3/09.

 

[joeu2004]

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.

 

[Harsh Bahal]

Hi Driller,

You are right , I have not recd any notification for the same.

 

[Harsh Bahal]

I will get back directly to you.

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).



A specific example would be helpful, to say the least.