COUNTIF HELP.

Nico Sebastian

Hello all. My question is in regards to a column of drop downs of yes or no.

Currently I am able to do for no perfectly. But for “yes” they only success i have had so far is if one dropdown is yes, then the cell i need turns green.

(Separate cell turns green or red)

My end goal is to have a dropdown list that doesnt turn completely green unless all dropdown yes have been completed.

so far i have tried using =countif(range, CONTAINS(“yes” or “all dropdowns yes”))

IdK if its a formula or wording issue.

thanks in advance

Andrée Starå

Hi @Nico Sebastian

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Steven Stikons

Hi Nico,

Assume your column with the yes/no drop downs is called "YesNo". Here is the formula you should use:

=IF(COUNTM(YesNo:YesNo) = COUNTIF(YesNo:YesNo, "Yes"), "Approved", "Pending Approval")

If you have any problems with the formula let me know.

Nico Sebastian

@Steven Stikons thank you so much for answering. Sharing is tough its within work and VPN wouldnt allow.

I did try that formula, but it did not work. May i ask could it be the wording of approval and pending approval?

C4-C13 have the dropdowns in them with YES or NO if that helps

Andrée Starå

@Nico Sebastian

Happy to help!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Steven Stikons

Hi Nico,

Try this:

=IF(COUNTM(c4:c13) = COUNTIF(c4:c13, "Yes"), "Approved", "Pending Approval")

Steven Stikons

Hi Nico,

Sorry - try this instead (this time with capitalized YES):

=IF(COUNTM(c4:c13) = COUNTIF(c4:c13, "YES"), "Approved", "Pending Approval")

Nico Sebastian

@Steven Stikons. thanks for answering. I tried the formula but it did not work.

currently i have a condition =COUNTIF($C4;$C13,”YES”)

and the cell i need populates if the first drop down is selected yes. I only need the drop to populate if All drops downs are yes.