COUNTIFS Formula Question


I am trying to create a COUNTIFS formula to determine how many stops by Sales Rep, By County, By State. I have created helper columns listing the counties in each state. The formula I have is:

=COUNTIFS(County:County, [Mark Counties]@row, State:State, "OK", Date:Date, YEAR(@cell) = YEAR(TODAY()))

It is pulling a count of all counties and not limiting by state so I am getting a higher number.

My goal is to show a graph (Pie Chart) showing % time spent by market. Any ideas?

Main Data Source

Helper Column:

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!