Beginner question

[jenny]

Please forgive what might be a beginner question.
I have a spread sheet that is made up of 10 columns.
I would like to make it so that each time I change a
number in these columns, the sub-total at the bottom
of each column changes automatically AND so that
the sub-total in the far right column changes automatically.

Is there a template for this??

Thanks so much!!!

 

[DS-NTE]

You would use a function for that, lets say you have values in A1 to A10,
then in A11 place this =SUM(A1:A10), or =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10.
got the idea??

 

[jenny]

You would use a function for that, lets say you have values in A1 to A10,
then in A11 place this =SUM(A1:A10), or =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10.
got the idea??

Could you walk me through the keystrokes?? Are you saying that I simply
type
A1+A2+A3+A4+A5+A6+A7+A8+A9+A10 and nothing else?? I tired that and
it didn't work.

 

[Ragdyer]

Perhaps you didn't notice that all formulas in XL start with an equal sign.

If you have a 10 column by 10 row array (A1 to J10), and you want to total
each individual column AND each individual row, start with this in A11:
=Sum(A1:A10)
And this in K1:
=Sum(A1:J1)

Now, XL allows you copy these formulas from cell to cell, and
*automatically* changes the cell references to accommodate for the new
location of the copied formula.
Copying the formula from A11 to B11 will result in the formula changing to:
=Sum(B1:B10)
And copying the formula in K1 to K2 will result in:
=Sum(A2:J2)

To copy a cell (formulas OR data), select the cell.
You'll notice a small square in the lower right hand corner of the
selection.
This is called the "Fill Handle".
Hover the cursor over this square until it changes from a fat white cross to
a skinny black cross.
Then click and drag this fill handle down a column or across a row as far as
you need to copy the original's contents.

In XL, there's always more then one way to accomplish any task.
Here are a few ways (formulas) that you could use to total the contents of
cells A1 to A10:

=Sum(A1:A10)
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
=Sum(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10)

Each syntax has it's own benefits which we won't get into here.

Post back with any further questions.

 

[Mickey Mouse]

Jenny,
Suppose you have numbers in A1 to A10 and you want to add them up and
display the answer in A11
Select the cell where you want the answer to go, in this case A11
then type =sum to tell excel to calculate what follows and that is (A1:A10)
which means add the contents of A1 to A10.
Therefore =sum(A1:A10) if placed in cell A11 means,
Add the contents of A1 to A10 and place the answer in A11.

Not that long ago I was in the same boat.

Mickey