IF function based on a Countif result

[mtaylor]

Hi Team,

This should be an easy one, I just can't seem to finish it off.

I want to count the number of TRUE values across 4 consecutive cells, and based on that number, if it is greater than 1, a P appears, if not a UA appears.

I'm currently using this:

=IF((COUNTIF(C3:F3,TRUE)>1),P,UA)

But I get the error occurring.

Many thanks in advance

Matt

 

[Peter_SSs]

Does this resolve the issue?

=IF((COUNTIF(C3:F3,TRUE)>1),"P","UA")

 

[mtaylor]

Does this resolve the issue?

=IF((COUNTIF(C3:F3,TRUE)>1),"P","UA")

As if I was that close!

Many thanks - all good!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.