Im unsure...do you know?

I have a column titled 'Amount inc Vat'. Different amounts will be entered each day into the cell rows underneath this title, ie;


TOTAL INC VAT
_____________
1500.25
959.25
25.50
10,525.00


What I would like is the Grand Total Amount spent to be displayed in a cell somewhere else on the worksheet so the manager can keep a track of what is being spent - get me? Like, an automatic calculator totalling up as differerent amounts are entered...

Not sure which formula that would be! Im a novice, so be gentle!

My data is in column 'L' by the way, and is located on a second worksheet called 'Accepted' (im working on 2 different worksheets).

Many thanks in advance!

Emma

I must be doing something wrong because it's not working :o(

The cell displays '#REF' or '#NAME?'

It should work...make sure the range you have only includes the numbers. It it tries to SUM the titles of the page Excel gets annoyed

Michael.

Michael - You are a star!! Many many thanks! It helped that you provided a nice step by step answer for me, cheers!! and Happy Christmas!

No problem

I only signed up to this forum today...it is a good place to come!

Merry Christmas to you too

Michael.

Originally Posted by genuinegal

I have a column titled 'Amount inc Vat'. Different amounts will be entered each day into the cell rows underneath this title, ie;


TOTAL INC VAT
_____________
1500.25
959.25
25.50
10,525.00


What I would like is the Grand Total Amount spent to be displayed in a cell somewhere else on the worksheet so the manager can keep a track of what is being spent - get me? Like, an automatic calculator totalling up as differerent amounts are entered...

Not sure which formula that would be! Im a novice, so be gentle!

My data is in column 'L' by the way, and is located on a second worksheet called 'Accepted' (im working on 2 different worksheets).

Many thanks in advance!

Emma

Hey, you just need to use a SUM function

It would just be =SUM("range")
Say it was from L1 down to L26 it would be =SUM(L1:L26)

If you are referring to it from another page, then you need to "pling" (i think that is the right word!) it, meaning it would become =SUM(Accepted!L1:L26)

If you dont want to type it, begin typing in '=SUM(' and then following the '(' you can just navigate to the page and highlight what you want it to SUM and then hit enter.

Hope that helped

Michael