excel formula

A

adinic

Hello. Does anyone know how to do the following thing in excel:

d5*e5+d6*e6...... and so on till 140th row. I tried the following
formula: sum(d5:e5*d41:e41), but didn't work.

Thank you very much!
 
D

Dave Peterson

How about:

=SUMPRODUCT(D5:D140,E5:E140)




Hello. Does anyone know how to do the following thing in excel:

d5*e5+d6*e6...... and so on till 140th row. I tried the following
formula: sum(d5:e5*d41:e41), but didn't work.

Thank you very much!
Click to expand...
 

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

Filter with an IF, AND, NOT formula 1
Conditional formating not working 5
Difficulty with formula 3
calculating percentage-using rows 4
NEED HELP WITH FORMULA, possible an array 4
using code variable to write cell formula 2
balance sheet problem 3
UserForm Issues 6

Top