Formula that allows it to calculate the sum of

Closed
RivkaJ Posts 2 Registration date Tuesday 8 April 2014 Status Member Last seen 8 April 2014 - 8 Apr 2014 à 12:25
RivkaJ Posts 2 Registration date Tuesday 8 April 2014 Status Member Last seen 8 April 2014 - 8 Apr 2014 à 14:11
Hi !

I'm looking to create a formula that allows it to calculate the sum of..

=SUM(D3*E3+D4*E4+D5*E5+D6*E6)... but it needs to do this from row 3 to row 128. The only way I know how is to contiune typing the same thing for each row..

There has to be an easier way..

I appreaicate your help.
Related:

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
8 Apr 2014 à 13:18
RivKaJ, Good afternoon.

Try this one:
=SUMPRODUCT((D3:D128)*(E3:E128))

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
RivkaJ Posts 2 Registration date Tuesday 8 April 2014 Status Member Last seen 8 April 2014
8 Apr 2014 à 14:11
Thank you !!!!!
:)