Formula request

[mac_see]

Let me put the scenerio across
The value of A1 is 1
The value of B1 is 2
The value of C1 is 3
The value of D1 is 4
The value of E1 is 5

The value of A2 is 100
The value of B2 is 200
The value of C2 is 300
The value of D2 is 400
The value of E2 is 500

The value of G1 is Row1
The value of G2 is Row2

H1 and H2 accepts value from the user.

If i have to put the value for
H1 to 2 and H2 to 4, the H3 cell should sum up the corresponding value from 2 to 4(B1:D1) that is 200+300+400=800

 

[mac_see]

I should thank you guyz for helping me out. I have another question. Cell A1 contains Tom, A2 **** and A3 Harry. Cell B1 contains 3 B2 5 and B3 1. Values in Cell B1,B2,B3 are dynamic and changes according to values present in another worksheets. What I want is in D1 D2 D3 and E1 E2 E3 the same values should be copied but will be sorted in decending order as the value in B1 B2 B3 changes.