CountifS with Distinct
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)
Best Answer

Try a COUNT/DISTINCT/COLLECT instead.
=COUNT(DISTINCT(COLLECT({Total URV Visits Range SID}, {Total URV Visits BEC}, @cell = District@row)))
Answers

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

Try a COUNT/DISTINCT/COLLECT instead.
=COUNT(DISTINCT(COLLECT({Total URV Visits Range SID}, {Total URV Visits BEC}, @cell = District@row)))

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


I did. It says unparsable.

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

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

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

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

Help Article Resources
Categories
Check out the Formula Handbook template!