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

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

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

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

"SteveC" wrote:

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

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

try this. Need NOT array enter
=SUMPRODUCT((C2:C50)*(D2:D50)*C2:D5)

--
Don Guillett
SalesAid Software

"SteveC" wrote in message
...
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

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

=SUMPRODUCT(A1:A4,B1:B4)

will do it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

"SteveC" wrote:

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

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

Don and Bob, thanks.

"Bob Phillips" wrote:

=SUMPRODUCT(A1:A4,B1:B4)

will do it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

"SteveC" wrote:

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