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.
Code: Select all
B2
=if(C2,null),,SUM(C2:E2)
I've tried the following with no success.
Code: Select all
=if(C2,null),null,SUM(C2:E2)
=if(C2,null),#null,SUM(C2:E2)
Thank you for any help you can provide.