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