I'm working on an inventory sheet that pulls from received items on Sheet #2 .
I have a couple of cells that contain variable (items) and I want to know if there's a way to have them added or subtracted from sheet 2 totals.
Explained:
sheet1, B7 contains either "shipped" or "returned".
G13...