Add/Subtract Cells depending on drop down choice

[valtinc]

Hey all,

I'm new here and I have been having an issue with a new spreadsheet. What I essentially want to happen is for a cell to have a formula to be able to compute either a subtraction or addition depending on a drop down choice I made through Data Validation.

I'll try to explain as best I can:

Cell G2 has the header "Quantity", H2 has "In/Out", I2 has "Quantity In/Out" and J2 has "Total"

H2 is the drop down. Any user can select either In or Out. What I want to happen is if the user selects, "In", Cells G2 and and I2 will be added for a total in "Total" in J2.

If a user were to select "Out" in in H2, then the cell I2 would be subtracted from G2 for a total in "Total" in J2.

I've been pondering this for a while to no avail, is there any way to combine sumif and a subtraction portion? Or something like that? Thanks for yall's attention.

[mehmetcik]

Put this formula in J2.

Please Login or Register  to view this content.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[valtinc]

Thank you so much! Worked perfectly!!