Forum Discussion
Solved
COUNTIFS Wizard Required Please
Hi, I’m looking for help please on what I believe should be a COUNTIFS formula. I’ve gone round in circles trying to work this one out but am losing the will…. I am currently using a COUNTIF formula...
=IF(A1>0, IF(B1>0, "Contracted", "Not Signed"), IF(B1>0, "Price Missing", "Not Contracted"))
=IF(A1>0, IF(B1>0, "Contracted", "Not Signed"), IF(B1>0, "Price Missing", "Not Contracted"))
Hans, that is brilliant. Thank you so very much. Best regards.