COUNTIFS

Robyn

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! 😀

MVP OPS

Hi Robyn,

Happy Monday,

I would suggest a helper column that references the statuses you have listed. I'm assuming that you want to count all rows that have each status "Complete, In Progress, Terminated, Not Started".

Add a helper check box column that has a this formula = (IF(OR(Contains("Complete", {Progress}), contains("In Progress", {Progress}), contains("Terminated", {Progress}), contains("Not Started", {Progress})), 1, 0)

Once you have this column then you can run a countif formula to count the number of checks.

Hope this helps,

Best

Brad

MVP OPS