Is there a template for this simple addition??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jenny - 20 Dec 2006 16:44 GMT

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.
And of course, I would like for the grand total at the bottom
of the far right column to change automatically.

Is there a template for this??

Thanks so much!!!

Reply to this Message

Gord Dibben - 20 Dec 2006 20:19 GMT

jenny

Assuming data in 100 rows columns A:J

In A101 enter this =SUM(A1:A100) to sum that column.

Drag/copy across to J101

In J102 enter =SUM(A101:J101)

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 7 lines]
>
>Thanks so much!!!

Reply to this Message

jenny - 21 Dec 2006 00:48 GMT

> jenny
>
[quoted text clipped - 7 lines]
>
> Gord Dibben MS Excel MVP

I'm sorry, I couldn't do it. I need more explicit instructions.

I tried dragging and highlighting a row. No sweat. But then when I click
on
the total cell at the end of that row, I don't get how to make it
automatically
total each cell to the left of it.

Reply to this Message

Gord Dibben - 21 Dec 2006 02:14 GMT

jenny

At the bottom righthand corner of A101 is a small black square.

After entering =SUM(A1:A100) in A101.............

Hover the mouse pointer over that square until you see a black cross.

Left-click on that then drag across to J101

Let go the button.

Each column will now have a SUM of the column in cell 101

In J102 just enter the formula =SUM(A101:J101) which will SUM all the SUMs in
row 101

If you don't see a small black lunp then go to Tools>Options>Edit and checkmark
"Allow cell drag and drop".

Gord

>> jenny
>>
[quoted text clipped - 15 lines]
>automatically
>total each cell to the left of it.

Gord Dibben MS Excel MVP

Reply to this Message

jenny - 21 Dec 2006 00:56 GMT

> jenny
>
[quoted text clipped - 5 lines]
>
> In J102 enter =SUM(A101:J101)

When I drag down a row to highlight all the numbers that I want
to total and terminate that drag/highlight on the cell that I want to
be the grand total, I think click Go but that doesn't work. Then I
click Okay, but that doesn't work either. In fact, when I click on
the grand total cell, all my highlight goes away.

Reply to this Message

Gord Dibben - 21 Dec 2006 02:14 GMT

Might be you don't have Tools>Options>Edit "Allow cell drag and drop" checked.

See other post for more details.

Gord

>> jenny
>>
[quoted text clipped - 11 lines]
>click Okay, but that doesn't work either. In fact, when I click on
>the grand total cell, all my highlight goes away.

Gord Dibben MS Excel MVP

Reply to this Message