vkbothra
(Learning )
(690 Points)
Replied 18 December 2010
Dear TOPIC Poster
Its as simple as you do sum in excel sheet. here is the formula of your query. just follow the step, copy all your these no. and paste in first cell (A1) of excel sheet AND at in cell no. A16 paste the formula which is in bold letters.
for eg.
556
654
822
-456
-64
564
68
-900
=SUM(A1+A3+A5+(A7)+(A9)+A11+A13+(A15))
hope this will help you ;)
satya
(Executive Excise)
(1839 Points)
Replied 22 December 2010
Dear VKBothra,
Can U explain it clearly,
vkbothra
(Learning )
(690 Points)
Replied 22 December 2010
Dear its so simple
copy and paste all this no.s in your new excel sheet, ok?
556
654
822
-456
-64
564
68
-900
and now paste this formula at last of all the nos.
=SUM(A1+A3+A5+(A7)+(A9)+A11+A13+(A15))
and you are done ;)
vkbothra
(Learning )
(690 Points)
Replied 22 December 2010
for eg.
in A1 write 556
in A3write 654
in A5 write 822
in A7 write -456
in A9 write -64
in A11 write 564
in A13 write 68
in A15 write -900
and in A16 write the whole formula
=SUM(A1+A3+A5+(A7)+(A9)+A11+A13+(A15))
satya
(Executive Excise)
(1839 Points)
Replied 22 December 2010
There are 8 nos, some in -ve also, you are doing like zigzag, SUM(A1+A3+A5+(A7)+(A9)+A11+A13+(A15)) why? please explain?
are u using any special formula, u r using up to cell a15. where as data contains up to cell 8.
vkbothra
(Learning )
(690 Points)
Replied 22 December 2010
this is because there are some nos. in -ve value,
and in excel we will use bracket for -ve value nos.
:)
Susan Garcia
(Manager)
(26 Points)
Replied 22 December 2010
Hello
I have gone through your thread it was so useful, can any one tell me what is formula to combine two cell with space in middle
P K
(Excel Developer)
(130 Points)
Replied 23 December 2010
formula to combine two cell with space in middle
Example:
A1=Name
B1=18
Formula
=A1&" "&B1
Result = Name 18
P K
(Excel Developer)
(130 Points)
Replied 23 December 2010
for addition of above
in A1 write 556
in A3write 654
in A5 write 822
in A7 write -456
in A9 write -64
in A11 write 564
in A13 write 68
in A15 write -900
and in A16 write the whole formula
=Sum(A1:A15)
vkbothra
(Learning )
(690 Points)
Replied 23 December 2010
Yeah v. right dear,
this is also a simple way to calculate +ve and -ve value together ;)
thanks
Live Course on Invoice Management System (IMS) - 2nd Batch(With Recording)
CAclubindia
