formula for adding and subtracting in the same cell

[shaftdx]

I have a column adding up all the hours owed to an employee =sum(G4:G22) I need to be able to subtract the hours we did give them which would be populated in I4:I22. how do I get that in the same cell? adding from one column but taking away from another.

 

[alansidman]

If I am understanding your request correctly then

=Sum(G4:G22)-Sum(I4:I22)

 

[arthurbr]

Perhaps

=sum(G4:G22)-sum(I4:I22)

 

[shaftdx]

Thank you so much, I knew it was something insanely simple that I was missing...like the second set of parenthesis...

 

[arthurbr]

I don't mean to be rude, but how can one know that the answer is simple without knowing the answer ? ?

 

[shaftdx]

I don't mean to be rude, but how can one know that the answer is simple without knowing the answer ? ?

it was one of those deals where I was looking at the formula and you could just tell something was missing. it just did not look right.