how to get the total of two lines

[sumesh56]

i want to sum up two rows of data into the third row. how can i d
that?pls see the attached file

+-------------------------------------------------------------------
|Filename: TEST TOTAL OF TWO LINES 040414.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=968
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Fri, 4 Apr 2014 11:32:34 +0100 schrieb sumesh56:

i want to sum up two rows of data into the third row. how can i do
that?pls see the attached file.

try:
=SUM(S2:AH3)


Regards
Claus B.

 

[zvkmpw]

i want to sum up two rows of data into the third row. how can i do

that?pls see the attached file.
http://www.excelbanter.com/attachment.php?attachmentid=968|

Here's one way.

In B4 put
=B2+B3
Then copy B4 and paste into C4:AI4.

Then copy B4:AI4 and paste into both B7:AI7 and B11:AI11.

 

[sumesh56]

Here's one way

In B4 pu
=B2+B
Then copy B4 and paste into C4:AI4

Then copy B4:AI4 and paste into both B7:AI7 and B11:AI11

from the responses i think there is no shortcut method to solve thi
issue. what you have suggested is something like get the total of B2+B
in B4 and then drag B4 to the destination cell you get the total.
wanted to avoid the effort on my wrist when this drag process on ver
long line of data spread into different rows.but your copy paste metho
is something new technique , thank you for the direction

+-------------------------------------------------------------------
+-------------------------------------------------------------------