Countif with Multiple Criteria

Victoria Harrell

I am trying to get a count if VP = "Name" and Indent Level is not 0 AND an additional column does not contain "payments".

My formula is:

=COUNTIFS({NEW Client Onboarding Spreadsheet Range 1}, ="Sam Moses", {NEW Client Onboarding Spreadsheet Range 4}, <>"Payments", {NEW Client Onboarding Spreadsheet Range 2}, <>0)

However, the count keeps coming back with 0 when it should come back with 3. What am I doing wrong?

Darren Mullen

@Victoria Harrell Is {NEW Client Onboarding Spreadsheet Range 1} a contact column?