CountifS with Distinct

frob

I need a function to count how many time a territory as unique SIDs in a sheet. I tried the function below but it won't work.

=COUNTIFS({Total URV Visits Range SID}, DISTINCT({Total URV Visits Range SID}), {Total URV Visits BEC}, District@row)

Paul Newcome

Try a COUNT/DISTINCT/COLLECT instead.

=COUNT(DISTINCT(COLLECT({Total URV Visits Range SID}, {Total URV Visits BEC}, @cell = District@row)))

Eric Law

@frob What are you trying to do? Can you post some screens? I don't think you are using DISTINCT correctly.

Paul Newcome

Try a COUNT/DISTINCT/COLLECT instead.

=COUNT(DISTINCT(COLLECT({Total URV Visits Range SID}, {Total URV Visits BEC}, @cell = District@row)))

frob

I need to count how many times this sheet has a unique SID for Appalachian for example.

Paul Newcome

Did you try my formula?

frob

I did. It says unparsable.

Paul Newcome

Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

frob

This is my summary sheet that I'm trying to pull the counts into so I can make a graph.

Paul Newcome

You entered an extra closing curly bracket after the second cross sheet reference that needs removed.

frob

Arg!! It's always something dumb like a bracket or comma. It works now! Thank you!!!

Paul Newcome

Happy to help. 👍️