IF function based on a Countif result

mtaylor

New Member
Joined
May 1, 2013
Messages
49
Platform
  1. Windows
  2. MacOS
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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,474
Office Version
  1. 365
Platform
  1. Windows
Does this resolve the issue?

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

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,474
Office Version
  1. 365
Platform
  1. Windows
You're welcome. Thanks for the follow-up. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,140
Messages
5,570,404
Members
412,322
Latest member
mohi021
Top