Help on formula

[jiteshmehta2k1]

Hi,

I have raw data which has the following:

• Each row signifies a company
  
  
• I have Countries as columns
  

I need a formula to check if a given company has employees in say minimum 2 and maximum 5 countries out of a given set of countries.


Refer excel for details.

Thanks in advance

 

[eibi]

Something like this?

=IF(AND(COUNT(I2:N2)>1,COUNT(I2:N2)<6),TRUE,FALSE)

 

[Khalid NGO]

Something like this?

=IF(AND(COUNT(I2:N2)>1,COUNT(I2:N2)<6),TRUE,FALSE)

Hi Isac,
"IF" can be removed
=AND(COUNT(I2:N2)>1,COUNT(I2:N2)<6)

 

[jiteshmehta2k1]

Thanks eibi and Khalid. Marking it as solved.