Previous Topic Next Topic

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.
Related:

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
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

Hello,

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

Hello
Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the position of the students i.e first , second, third etc. I will be glad and praiseworthy if u can help me out
...

Configuration: Windows 7 / Safari 536.11

12 responses
calculating fuel surcharge
Nancy -
xpcman -

Hello,

I have the amount which includes freight charge+fuel surcharge that is $14.36. It is said that fuel surcharge is 22%. what formula should we enter in excel to get the break down of the charges .. freight and fuel separate or the actual freight charges excluding the fuel surcharge...please let me know, it is urgent

Thanks!!

Configuration: Windows 7 / Chrome 43.0.2357.124

1 response
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel has to select Six Subjects from Nine Subjects, with Four being compulsory and Two other best. I want an excel formular that will add the grade value of four compulsory subjects : English, Maths, Science, Social. And then automatically select 2 other subjects from the rest with best grade value.



For Instance, If a student has the following result:

1. English - 2

2. Maths - 1

3. Science - 1

4. Social - 2

5. ICT - 3

6. BDT - 3 ...

2 responses