Sum/multiply function
 

Experts,

I am looking to multiply column A by column B and then sum multiple rows in
a single step.

Example:

A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5

I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.

Ryan

Sum/multiply function
 

=sumproduct(A1:A5,B1:B5)

"Ryan Gerry" wrote:

Experts,

I am looking to multiply column A by column B and then sum multiple rows in
a single step.

Example:

A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5

I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.

Ryan

Sum/multiply function
 

=SUMPRODUCT(A1:A5,B1:B5)

This is EXTREMELY power function!
See:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Gary''s Student - gsnu200856


"Ryan Gerry" wrote:

Experts,

I am looking to multiply column A by column B and then sum multiple rows in
a single step.

Example:

A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5

I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.

Ryan

Sum/multiply function
 

=SUMPRODUCT(A1:A5,B1:B5)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Ryan Gerry" wrote in message
...
Experts,

I am looking to multiply column A by column B and then sum multiple rows in
a single step.

Example:

A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5

I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.

Ryan

Sum/multiply function
 

I figured it would be something super simple. Thanks all!

Ryan

"RagDyeR" wrote in message
...
=SUMPRODUCT(A1:A5,B1:B5)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Ryan Gerry" wrote in message
...
Experts,

I am looking to multiply column A by column B and then sum multiple rows
in
a single step.

Example:

A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5

I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.

Ryan

Sum/multiply function
 

Appreciate your feed-back.

It's not too often that we see triple headers!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ryan Gerry" wrote in message
...
I figured it would be something super simple. Thanks all!

Ryan

"RagDyeR" wrote in message
...
=SUMPRODUCT(A1:A5,B1:B5)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Ryan Gerry" wrote in message
...
Experts,

I am looking to multiply column A by column B and then sum multiple rows
in
a single step.

Example:

A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5

I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.

Ryan