I have a problem I have been trying to sort but with no success.
On the sheet that is attached I have a SUBPRODUCT formula that is in row 18 that produces 2 if correct in row 12
There is another SUBPRODUCT FORMULA IN ROW 20 that produces 5 if correct,
What I want is if the formulas in row 20 produce 5 then the rows 18 produce 0 instead of 2,
I have made it sound more complicated than it is .but the attachment will help
Thank you for any input John
Bookmarks