COUNTIFS Formula not picking up additional rows

Matt Pittman

I created a COUNTIFS Formula to tabulate results from a column containing responses from a Multi Select Drop Down Form. Once I go the formula right, it calculated correctly but as additional rows have come in to the sheet, it isn't picking up those additional rows. One cell is still showing the original value, though based on my manual count the result is more than twice that number.

Any ideas.

Here's the formula: =COUNTIFS([Potential Training Topics]:[Potential Training Topics], HAS(@cell, "Builds Effective Teams: Behavior Based Interviewing"))

Andrée Starå

Hi @Matt Pittman

I hope you're well and safe!

Strange!

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 week!

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!