COUNTIFS cross-sheet with 3 criteria

System

This discussion was created from comments split from: CountIf Formula with Multiple Criteria in the Same Column.

Melanie Sanders

@Paul Newcome I have a similar formula and tried to use your example above but it didn't work. I am using a cross-sheet and have 3 criteria I need to count by each location. Can you assist? I have been looking at all sorts of formulas in the help section and everytime I think I found my answer....I still get the error unparseable.

=COUNTIFS({Location # and Name}, LOCATION@row, {Claim Status 4}, OR(@cell = "Pending - With Vendor", OR(@cell = "Pending - With Vendor AP", OR(@cell = "Pending - With AP"}))

Thank you,

Melanie

Paul Newcome

@Melanie Sanders You do not need multiple OR statements.

=COUNTIFS({Location # and Name}, LOCATION@row, {Claim Status 4}, OR(@cell = "Pending - With Vendor", @cell = "Pending - With Vendor AP", @cell = "Pending - With AP"))

Melanie S

Thanks, @Paul Newcome