Excel 2002

aardvaak

I am using Excel 2002 can someone please tell me how I can add a list of figure (£'s & P's) ie line 2 to line 33 and put the total in line 36?

Sagz_2

Try this:
click in the cell where you want the total
click 'autosum' on the toolbar
highlight the cells you want to add together
hit enter.

aardvaak

Norbertsmum wrote: »

Try this:
click in the cell where you want the total
click 'autosum' on the toolbar
highlight the cells you want to add together
hit enter.

Thank you where do I find Autosum?

aardvaak

Norbertsmum wrote: »

Try this:
click in the cell where you want the total
click 'autosum' on the toolbar
highlight the cells you want to add together
hit enter.

Just founds it little greek sign did that and said 0

Sagz_2

did you manage to highlight the cells to be added with the dotted line?

Sagz_2

This may help:
http://www.jegsworks.com/lessons/numbers/intro/step-autosum.htm

aardvaak

Norbertsmum wrote: »

did you manage to highlight the cells to be added with the dotted line?

Yes I got the dotted lines and in the box I wanted the total I got =SUM(R[-34]C:R[-3]C) the when I hit enter got 0

googler

Assuming everything you've referred to is in Column A of the sheet, type this in A36

=SUM(A2 A33)
(in the space between A2 and A33, type a colon - : MSE wants to put a smilie instead of colonA)

OR

Type =SUM( in A36, then use your mouse to highlight A2, and either drag the mouse to highlight to A33 / use Shift+Cursor Down to highlight to A33, then hit Return to complete the formula, which should give you the text above in A36.

If in column B, substitute B for A in all of the above.

Does this help?

aardvaak

Does it make any difference that the row I want to add (D) is written with £ & p signs ie £1.57p ?

googler

Select the cells you want to add up, and go to the Format menu - select Cells, and make sure they are formatted as 'Currency' not 'Text'

aardvaak

googler wrote: »

Select the cells you want to add up, and go to the Format menu - select Cells, and make sure they are formatted as 'Currency' not 'Text'

Thank you for your help - I think they were formatted as General.

I have now solved it by taking out the £'s & p's signs then highlighted to row to the box I wanted the answer then clicked Autosum button.

Could I of left the symbols in if I had formatted as currency?