Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to calculate the sum of figures in a row, in excel?

user-image
Question added by JITHIN PEEDIKAKKAL DOMINIC , Finance and Logistic Manager , District General Trading
Date Posted: 2016/12/12
Abd El Hamid Ibrahim El Desuky Abd El Latif
by Abd El Hamid Ibrahim El Desuky Abd El Latif , General Manager of Planning and Follow-Up , Alexandria Petroleum Co.

the right method is sum(Range of cells..) function / if you add some rows the function will edited automaticilly / if some cells is not digitals ( string) wil not affect your function ; othrewise using (a1+b1     ) may result  un coreect 

Muhammad Safdar
by Muhammad Safdar , Accountant & Inventory Control , SURGITECH MEDICAL SUPPLIES LLC

1. You can Use Short Cut Key:   Alt + =

2. Use Auto Sum  ∑  Button in Top Right buttons (in Home Ribbon)

3. Enter Formula in the required Cell:  =sum(1st cell reference:last cell reference)

How to calculate the sum of figures in a row in excel

MOHAMMAD TAJBABA
by MOHAMMAD TAJBABA , Sales Executive , Musaddilal Jewellery Pvt. Ltd

 

in the use microsoft excel shift cells down and shift cell right option ,the right method is sum ( 1a,1b)Range of cells function / if you add some rows the function will edited automaticilly / if some cells is not digitals string wil not affect your function ;rows colms and othrewise using a1+b1may result  un coreect 

 

More Questions Like This