Tolley123
Apr 21, 2023Copper Contributor
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:
- If A1 and B1 are both >0: “Contracted” and,
- If A1=0, and B1>0: “Price Missing” and,
- If A1>0, and B1<1: “Not Signed” and,
- If A1 and B1 are both <1: “Not Contracted”
Help would be very much appreciated. Many thanks in advance, Martin
=IF(A1>0, IF(B1>0, "Contracted", "Not Signed"), IF(B1>0, "Price Missing", "Not Contracted"))