Formula that allows it to calculate the sum of

Closed

RivkaJ Posts 2 Registration date Tuesday April 8, 2014 Status Member Last seen April 8, 2014 - Apr 8, 2014 at 12:25 PM
RivkaJ Posts 2 Registration date Tuesday April 8, 2014 Status Member Last seen April 8, 2014 - Apr 8, 2014 at 02:11 PM

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.

Formula that allows it to calculate the sum of
Logitech formula vibration feedback wheel driver - Download - Drivers
Number to words in excel formula - Guide
Excel grade formula - Guide
Vat calculation formula - Guide
Date formula in excel dd/mm/yyyy - Guide

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 8, 2014 at 01:18 PM

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 April 8, 2014 Status Member Last seen April 8, 2014
Apr 8, 2014 at 02:11 PM

Thank you !!!!!
:)

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

calculating fuel surcharge

Similar discussions

Subscribe To Our Newsletter!