Calculate sum of product in Excel 2003

  • Thread starter Thread starter Mosaddeq Aziz
  • Start date Start date
M

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
 
One of the few times that this is being used as Redmond originally designed
it for:

=SUMPRODUCT(A1:A4,B1:B4)
 
=SUMPRODUCT(A1:A50,B1:B50)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
You must have been really waiting for a suggestion since your response was
almost instant!<bg>

Appreciate the feed-back.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table calculated field Count(field) / sum(field) 0
Very strange behaviour of VLOOKUP in Excel 2010 4
In a sales quote sheet - sum totals by license type 1
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Counting unique values in multiple columns 4
Sum of products 2
Looking formula that SUM values with specific value in neighboring colum 2

Back
Top