Need a code modified

[ipbr21054]

Hi,
I have the following code which works well but i need it altered so i can subtract another figure from another excel worksheet.
The code i currently use is as follows,
=SUM('INCOME (1)'!G32 -'EXPENSES (2)'!K32)

This is a very simple code in that it just subtracts the figure on my expenses sheet from the figure on my income sheet.
The extra bit of code i need added etc is a figure from my mileage sheet in cell c32
What i am currently doing is taking my original figure then manualy subtracting the figure in the cell c32 on the mileage sheet.Just thought it would be good if the figures would do the magic as input is added.
Been trying to work it out but no luck so far.
Thanks

 

[jasonb75]

If the patter follows on the sheetnames, your description would suggest

=SUM('INCOME (1)'!G32 -'EXPENSES (2)'!K32)-'MILEAGE (3)'!C32

 

[ipbr21054]

Hi
When i enter that code i get a box appear asking to update values ?

 

[jasonb75]

You didn't give the exact name of the mileage sheet so i had to guess.

=SUM('INCOME (1)'!G32 -'EXPENSES (2)'!K32)-'MILEAGE (3)'!C32

you need to edit that to match your sheet name

 

[ipbr21054]

Now sorted
I removed the (3) as the others were page (1) on income and (2) on expenses,and i only have 1 mileage sheet.

Thanks for the quick reply