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?
