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
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
How to calculate 90 days from date in excel - Guide
Excel grade formula - 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

calculating fuel surcharge

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

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!