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.