Easy Formula?

  • Thread starter Thread starter xtrmhyper
  • Start date Start date
X

xtrmhyper

I Have A Column A & B
I Have A Formula At Column C =sum(a2*b2)+(a3*b3)+(a4*b4)
Answer Is 31
I Want To Multiply A1 And B1 Up To The Last Range Of Data Add The Total
Product
The Problem Is:
If Have A Lot Of Data In Column A & B, The Formula Is So Very Long
Theres Any Easy Formula?



A B
3 5
2 7
2 2
 
=sumproduct(a1:a100,b1:b100)
will multiply a1*b1, a2*b2, etc and add them up
 
You must log in or register to reply here.

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

Very strange behaviour of VLOOKUP in Excel 2010 4
find oldest date with a condition 4
Data Validation and drop-down list using IF, AND and what else? 8
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Lookup 14
Writing a formula...is there an easier way? 1
Need Help with a Formula 4
Formula Query 9

Back
Top