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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
formula for adding and subtracting in the same cell
- Thread starter shaftdx
- Start date
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 6,141
- Office Version
-
- 365
- 2019
- Platform
-
- Windows
If I am understanding your request correctly then
=Sum(G4:G22)-Sum(I4:I22)
=Sum(G4:G22)-Sum(I4:I22)
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.I don't mean to be rude, but how can one know that the answer is simple without knowing the answer ?
Similar threads
- Solved
- Locked
- Question
Watch MrExcel Video
Forum statistics
Share this page
We've detected that you are using an adblocker.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back