Formula that allows it to calculate the sum of [Closed]

Report
Posts
2
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014
-
Posts
2
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014
-
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.

1 reply

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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
Posts
2
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014

Thank you !!!!!
:)