excel formula

556

654

822

-456

-64

564

68

-900

in excel addination of this by formula


Replies (11)

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)

Yeah v. right dear,

this is also a simple way to calculate +ve and -ve value together ;)

thanks
 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details