SUMPRODUCT and blank or 0 value cells

[lazydogne]

Hello All -

I have a rather simple SUMPRODUCT formula I'm trying to get working, but I can't seem to figure out the needed condition for blank cells or 0 values (at which point, I will get a VALUE Error)

I have two columns that I want to multiple each row and then sum the total of all rows.

I've read a ton of other posts on using conditions IFERROR or ISNUMBER, but I've been unable to make any of them work.

This is where I left off on the formula I was working on:

=SUMPRODUCT($C$3:$C$200*($C$3:$C$200>1),$G$3:$G$200*($C$3:$C$200>1))

Anywhere within Rows C or G could exist a blank cell or 0 amount. If either of the conditions exists, then I don't want the the multiplication of the row to happen and of course not be added to the total.

Thoughts?

LDN

[Limor_OP]

can you upload the excel file to see your data?

[ben_hensel]

I don't understand why you need to do anything to handle it at all, actually.

If there's a zero in the row, it will turn the row-result to zero, so it won't change the sum of rows, right?

And text or blank cells also get treated as zero, so likewise, they will end up being treated as +0 in the summation.

So can't you just use:

Please Login or Register  to view this content.

and get exactly what you want?