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
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