COUNTIFS Wizard Required Please

Occasional Contributor

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 with one input cell, yielding one of two text-string results. Going forward I need to introduce a second input cell, the results of the combination of both cells are to yield one of four text-string results.

The two input cells, for simplicity will be A1 and B1, which are to yield the text string in C1.

The result is to be a text string:

  1. If A1 and B1 are both >0:  “Contracted” and,
  2. If A1=0, and B1>0:  “Price Missing” and,
  3. If A1>0, and B1<1:  “Not Signed” and,
  4. If A1 and B1 are both <1: “Not Contracted”

Help would be very much appreciated. Many thanks in advance, Martin

2 Replies
best response confirmed by Tolley123 (Occasional Contributor)



=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.