subtotals

[Phil]

I am trying to do a running subtotal for an account book. Cells B5-B44
have amounts in and I want to have a running total in the
corresponding cell in C column without typing out long hand in every
cell.

I cant figure out the Subtotal function , can anyone assist please ?

 

[JulieD]

Hi Phil

not sure what you mean by subtotal here
is this what you want
B C
5 10 10
6 20 30
7 10 40

if so the formula in C5 is =B5
the formula in C6 is =B5+B6
and then fill down (move mouse over bottom right hand corner of the cell
until you see a +, then just double click and this should go fill the
formula down to row 44 .. if that doesn't work, hold down the left mouse
button on the + and drag down as far as you want and then left the mouse go)

Hope this helps
Cheers
JulieD

 

[Phil]

Blimey, this Excel stuff is simple when u know how. So many neat
little tricks. thankx a lot

 

[JulieD]

Hi Phil

you're welcome ...yep, excel's full of fun little shortcuts

Cheers
JulieD