Hi,

Can anyone help? I learnt this at school/uni but have promptly forgotten. I need to know how to forumlas on excel, across multiple worksheets. I know how to do them on one sheet, but I want to put figures in one and be able to subtract the figures in it from a total in another worksheet? Does anyone know how to help me? Thanks

Just variations on this:

=Sheet2!C7+Sheet3!D10-Sheet4!AB23

One easy way is to have all sheets open and click to enter the relevant cells into your formula.