556
654
822
-456
-64
564
68
-900
in excel addination of this by formula
556
654
822
-456
-64
564
68
-900
in excel addination of this by formula
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 ;)
Dear VKBothra,
Can U explain it clearly,
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 ;)
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))
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.
this is because there are some nos. in -ve value,
and in excel we will use bracket for -ve value nos.
:)
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
Icon Infosystems
kindly eleborate your question plz. :)
formula to combine two cell with space in middle
Example:
A1=Name
B1=18
Formula
=A1&" "&B1
Result = Name 18
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)
Your are not logged in . Please login to post replies
Click here to Login / Register
N N V Satish & Co.,
Hyderabad
CA Inter
View Details
Saini Pati Shah & Co LLP, Chartered Accountants
Mumbai
CA Final
View Details
CCI
Pro
India's largest network for
finance professionals