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

S

SteveC

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
 
S

SteveC

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

Bob Phillips

=SUMPRODUCT(A1:A4,B1:B4)

will do it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top