XCEL formual for addition

[tms05]

In Xcel, I am trying to add up numbers in 10 rows in column A and then the numbers in two rows in column B but I can't get a formula for it. DO you know of a formula? Thanks.
A B
20
4
5
115 41
10
6
7 4
8
92
311

 

[SkipVought]

Hi,

Check out the SUM function...
[tt]
=SUM(A1:A10)
[/tt]
Copy the formula and paste in the adjacent cell to the right, for the column B total.

Or...
[tt]
=SUM(A1:B10)
[/tt]
to get the total of both.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[tms05]

That is what I did, but in the field it doesn't put the total, it puts the formula. Do you know why. I even went to format and put General, text, number, custom, and it still puts the formula instead of the total. Thanks for answering me.

 

[SkipVought]

Use the GENERAL format. Edit the formula and hit ENTER.

If that fails to work, then Tools > Options - VIEW Tab: UNCHECK Formulas in Window Options

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[tms05]

Thanks, appreciate it. I tried that, but formula was already unchecked. Still couldn't get it to work, so guess what? The field was checked as locked. Unlocked and it worked. Thanks. Can you also tell me what the little green spec in the left top corner of each cell means? Thanks.

 

[AnotherHiggins]

that means there's a warning message about the cell. Hover the cursor over the green arrow to see the message.

There's a good chance you won't care about the 'problem' excel is trying towarn you about. If that's the case, then you can select all of the cells with that message, hover over a green arrow, and xhoose "ignore message".

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[tms05]

Thanks for all your help, I appreciate it. Have a good weekend.