COUNTIF not returning correct amount of rows

ross chambers

hi i have a formula in my sheet summary that uses a countif formula to to count how many rows contain "Eng Ops" in my "Function" column. the formula puts out 31 as the answer but when i filter the sheet to show rows containing "Eng Ops" they're 35 rows.

=COUNTIFS(Function:Function, CONTAINS("Eng Ops", @cell))

sharkasits

@ross chambers What type of field is Function? Is it text or a multi value dropdown?

Paul Newcome

In addition to @sharkasits's questions... Are you able to provide a screenshot of those 35 rows (just the column in question is needed)?

Andrée Starå

Hi @ross chambers

I hope you're well and safe!

Strange!

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

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!