Now, I have a few products that are SUM'd anyway, those would be the green colored products. That's a simple SUM formula. But the red colored products only matter if there are actual on hand quantites [# of units]. I had written an IF formula but it keeps erroring and I'm not sure what to do to make it work.
I've tried the following with no success.
Thank you for any help you can provide.