What Formula to use to Count the number of Unique Dropdown Phrase Utilized

Austenp

I'm new to Smartsheets and I've been tasked with going over the SWOT data. They are asking me to go over each category of SWOT with the unique data point they captured and tallying how many times that data point is utilized. The Data Point Column is a dropdown list.

For example, I am having a hard time counting how many times Academic Support was flagged for a Strength. There are hundreds of entries, and I am looking for a faster way of doing it without having to count each one. Any suggestions would be greatly appreciated

!

Paul Newcome

You would use a COUNTIFS

=COUNTIFS([Data Point]:[Date Point], @cell = "Academic Support", [SWOT Category]:[SWOT Category], @cell = "Strength")

Paul Newcome

You would use a COUNTIFS

=COUNTIFS([Data Point]:[Date Point], @cell = "Academic Support", [SWOT Category]:[SWOT Category], @cell = "Strength")