I have two formulas that are currently returning correct values, but I want to combine them and only return the count if both criteria are fulfilled:
=COUNTIF({Approved Avalara Fixes - Form Required Range 1}, "Name")
=COUNTIF({Approved Avalara Fixes - Form Required Range 7}, NOT(@cell = "Child"))
Above are the two formulas I need to combine into one COUNTIFS:
=COUNTIFS({Approved Avalara Fixes - Form Required Range 1}, "Name", ({Approved Avalara Fixes - Form Required Range 7}, NOT(@cell = "Child")))
However, the combined formula returns "Unparseable". How can I combine these two formulas?