I have a formula that works perfectly, however I need to add two conditions and I got a bit lost.
here is the formula
I've shown the two conditions on two lines for easier identification.
You can see there are two conditions
The extra two conditions I would like to add to both of the above two conditions
Return zero if both conditions qualify. I want to apply to both of the conditions in the formula.
Please refer to attached sheet