I want the total count from 2 sheets from a column with multiple leads

PDunn

When I created the first formula it worked, when I add the second one linked to another sheet I get the nested criteria error. Even when I remove the extra end parenthesis still an error. Separately these both work together it doesn't work

Hollie Green

It seems to be the Has in your formula try replacing the Has formula with a Contains formula

Paul Newcome

You can keep the HAS. The issue is parenthesis. Take two from the very end and use the to close out the first OR and first COUNTIFS before the +.

You have

=COUNTIFS(………………) + COUNTIFS(…………..)))))

You should have

=COUNTIFS(…………..))) + COUNTIFS(…………….)))

PDunn

@Paul Newcome Amazing as always I tried all kinds of combinations. It worked thank you so much for the quick reply

Paul Newcome

Happy to help. 👍️