Subtract a range of cells

[wbco]

How do I subtract a range of numbers in Excell? Lets say I have numbers in A1 thru A50.

 

[JackDanIce]

Subtract from where?
In cell C1:

=B1-A1

Then drag the formula down to C50

 

[wbco]

Hmmm.... that didn't work? It just gave me #VALUE!

Lets try this....

A1 1000
B1 343
C1 121
D1 62
E1 12

F1 (formula to subtract the above)

 

[stefankemp]

=a1-sum(b1:e1)

 

[texasaswang]

Assuming you want to subtract all from the first cell?

=A1-(Sum(B1:E1))

 

[wbco]

Ahhh excellent. Thanks everyone!