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

One way
Place in say, B1: =SUM(A1:A200)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mjd23" wrote:
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/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 15:34:00 -0800, mjd23
wrote:

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