Excel 07: Copying calculation and autosum location

MsCynic

Board Regular
Joined
May 21, 2006
Messages
122
Hi guys, working my way through a large worksheet of figures which I need to sum according to date, and then calculate the amount of each date's figures with tax on top.

Autosum automatically places the sum of a column underneath the bottommost cell. Is there a way to put it at the side of the bottommost cell? Up to now I've been inserting a blank row beneath, then autosumming then dragging that cell to the right. Or else I can select the cells and type the sum in manually but it would be nice to tell Excel where I want the autosum result to be, without having to manually type in =sum(h29:h31) over and over.

Also, for my tax calculation I've been Ctr-dragging the formula downwards to apply it to the subsequent amounts. It retains the value of the earlier amount until I double-click on it to force a re-calculation. I'm sure I've had other formulas automatically update when I ctr-drag them so why not this one? =K150*(1+12.5%)

Thanks in advance for advice,
Jo
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,122,193
Messages
5,594,767
Members
413,933
Latest member
Msar5586

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top