excel formula

  • Thread starter Thread starter adinic
  • Start date Start date
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!
 
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!
 
Back
Top