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