Creating a Data Summary Sheet

Bert Guymer

Good Day, long time listener, first time caller…I'm trying to create a chart for a Dashboard and am having issues with a formula in my data collecting sheet. I have a column of District Managers and about 575 projects that I want to use the COUNTIFS function to pull in the status of projects in the SBR Status dropdown column of "Not Completed", "Scheduled, Not Completed" or "Completed". I can't wrap my head around it…any help would be appreciated.

Adam Murphy

Hi @Bert Guymer, I would try something like:

=COUNTIFS({District Manager}, [District Manager]@row, {SBR Status}, OR(@cell = "Not Completed", @cell = "Scheduled, Not Completed", @cell = "Completed"))

Hope this helps!

Bert Guymer

Thanks Adam!