G
Guest
What the formula for subtracting multiple columns?
Ex. Hours Work - Lunch - SickTime - Vacation = Total
9 1 3 0 Total
Ex. Hours Work - Lunch - SickTime - Vacation = Total
9 1 3 0 Total
M
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(B2
2)
where B22 houses all the items to be subtracted from A2
the 1st figure
Example, in E2: =A2-SUM(B2
2)where B2
2 houses all the items to be subtracted from A2
G
Guest
If value 9 is in column A1 (as below) then as follows:-
=A1-SUM(B11)
=A1-SUM(B1
1)
G
Guest
Or, if you prefer.........
=A1-(B1+C1+D1)
Vaya con Dios,
Chuck, CABGx3
=A1-(B1+C1+D1)
Vaya con Dios,
Chuck, CABGx3