adding cells in a colomn

  • Thread starter Thread starter mjd23
  • Start date Start date
M

mjd23

iam a new user to excel and i want to add up all the cells in a single row so
from A1 through to A200. does anyone know a formula i can use to add these
200 cells up? thanks anyone.
Dawn
 
A1:A200 is a range of cells in Column A, not a single row.

Rows are the 1,2,3,4,5, you see down the left side.

Columns are the A,B,C,D,E you see across the top.

=SUM(A1:A200) is the formula you need.

Enter that in any cell outside the range of A1:A200

For new users I post this information..........

Here are a few basic tutorials for Excel to get a beginner going.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/training/CR061831141033.aspx


Gord Dibben MS Excel MVP
 
Back
Top