I keep getting results of 0
I am trying to calculate the number of projects by their status and region (Atlantic and West) so I can than populate the information onto a pie chart on a Dashboard. I think I have been looking at this for too long and too many formulas examples and I am now overlooking something. Below is where I have left off with my formula. (I am referencing from a second sheet when entering this formula)
=COUNTIFS({Region}, "Atlantic, West", {Progress}, "Complete, In Progress, Terminated, Not Started")
Any help will be appreciated! 😀
