Formula for Subtraction in excel

[surajs84]

Hi,

Do we have a formula for subtraction similar to the sum function i.e. =SUM().

The reason why I am asking this is I want to reference a cell which has values across multiple tabs & i want to find the difference between all these tabs.

This is how the structure of my file is & i want to sum all the values under the cell A1:-

A
Tab X
Tab Y
Tab Z
B

so my formula for summing would be =SUM(A:B!A1) but I do not have the option of having a similar option for subtraction. Could someone guide me on this ?

 

[Asala42]

There is no function, but what output are you shooting for exactly?

Sheet1!A1-Sheet2!A1-Sheet3!A1?

That's just:
=A1-SUM(Sheet2:Sheet3!A1)

 

[surajs84]

Thanks Asala, that helps.

The solution is pretty simple .. just couldn't think of it .. thanks again