Calculate sum of product in Excel 2003

[Mosaddeq Aziz]

Hi Guys,

Sorry to bother you. I just couldn't find a way to solve it. Here is the
scenario,

A B
1 2 3
2 2 4
3 4 3
4 5 4

I need to find the sum of product in the column A and B. I can do this by
using a third column. I simply find the products then sum them. I need to do
this in one formula, not another column. I can do this by
=a1*b1+a2*b2+....... The problem is the columns have over 50 values.
Manually writing that would be real cumbersome. Any suggestion?

Mosaddeq

 

[Ragdyer]

One of the few times that this is being used as Redmond originally designed
it for:

=SUMPRODUCT(A1:A4,B1:B4)

 

[Mosaddeq Aziz]

Works like a charm. Thanks pal for the effort.

Mosaddeq Aziz

 

[Bob Phillips]

=SUMPRODUCT(A1:A50,B1:B50)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Guest]

=SUMPRODUCT(A1:A50,B1:B50)

 

[Ragdyer]

You must have been really waiting for a suggestion since your response was
almost instant!<bg>

Appreciate the feed-back.