What the formula for subtracting multiple columns?

Ex. Hours Work - Lunch - SickTime - Vacation = Total
9 1 3 0 Total

One way is to sum up all the bits to be subtracted, then just subtract from
the 1st figure

Example, in E2: =A2-SUM(B2:D2)
where B2:D2 houses all the items to be subtracted from A2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lonz" wrote in message
...
What the formula for subtracting multiple columns?

Ex. Hours Work - Lunch - SickTime - Vacation = Total
9 1 3 0 Total

If value 9 is in column A1 (as below) then as follows:-

=A1-SUM(B1:D1)



"Lonz" wrote:

What the formula for subtracting multiple columns?
A1 B1 C1 D1 E1
Ex. Hours Work - Lunch - SickTime - Vacation = Total
9 1 3 0 Total

Or, if you prefer.........

=A1-(B1+C1+D1)

Vaya con Dios,
Chuck, CABGx3



"Lonz" wrote:

What the formula for subtracting multiple columns?

Ex. Hours Work - Lunch - SickTime - Vacation = Total
9 1 3 0 Total