Forum Discussion

Tolley123's avatar
Tolley123
Copper Contributor
Apr 21, 2023

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

    • Tolley123's avatar
      Tolley123
      Copper Contributor
      Hans, that is brilliant. Thank you so very much. Best regards.

Share

Resources