Simple Sumproduct of 2 Columns, with some blank cells in range

[Guest]

ColA ColB
5 10
5 10
5
5 10

I'd like to sum the products of the two columns, while ignoring rows that
have a blank cell, so in this case (5*10) + (5*10) + (5*10) --->it's
skipping the third row.

I'm not having luck adjusting a simple =sumproduct(ColA,ColB) formula. I
did a search but didn't come up with anything that I understand how to
adjust.

Thanks for your help!
SteveC

 

[Guest]

aha, if you use an array formula ctrl shift enter it works... but is there
another way?

 

[Don Guillett]

try this. Need NOT array enter
=SUMPRODUCT((C2:C5>0)*(D25>0)*C25)

 

[Bob Phillips]

=SUMPRODUCT(A1:A4,B1:B4)

will do it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

Don and Bob, thanks.

=SUMPRODUCT(A1:A4,B1:B4)

will do it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)