COUNTIF not returning correct amount of rows

Options

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))

Tags:

Answers