COUNTIF? Would like to count text over a range of cells and if greater than or equal to 2 lots of text "" or if less than 2 lots of text ""

[LeighMacKay7]

Hi everyone,

I have had a really good experience so far in my short time using this site and am eternally grateful for all your help and support. (what a great site to be part of!!!)

I have run a large dataset, and I am interested in 7 columns specifically from this. All 7 columns contain text or blanks. But free text which has come from a form.
I think I need to create a COUNTIF statement that basically says, if 2 or more, of the columns contain text then return the text "Participating". 'and' If less than 2 of the 7 columns contains text then return "Supporting".

I am assuming it will be some sort of COUNTIF statement. But not sure where to even start in this instance.

I have created an example dataset below for the purposes of the response.
Lets just say the data is in cells B2, C2, D2, E2, F2, G2, and H2. Then the answer "Participating" or "Supporting" goes in cell I2.

Thank you in advance for your help
Leigh

 

[Shesil]

=IF(COUNTA(B2:H2)>1,"participating","supporting")

 

[LeighMacKay7]

=IF(COUNTA(B2:H2)>1,"participating","supporting")

Thank you for your response Shesil. This has been very useful.
Do you know how you would change the range to multiple specific cells. Is it worth using B2&E2&L2&Z2? Or do you recommend another method?

 

[Shesil]

Just use comma instead of &