Formulas

[Guest]

What the formula for subtracting multiple columns?

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

 

[Max]

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

Example, in E2: =A2-SUM(B22)
where B22 houses all the items to be subtracted from A2

 

[Guest]

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

=A1-SUM(B11)

 

[Guest]

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

=A1-(B1+C1+D1)

Vaya con Dios,
Chuck, CABGx3