Count Formula for At-Risk

ashley.elma

Hello,

Im trying to count all the At-Risk items for a specific team in the sheet summary. I have a Status column and a Team Owner column. Ideally, I would like to know what the formula would be for capturing the number of items At-risk for a specific team.

Brett Wyrick

Hey Ashley!

Your formula doesn't quite match up with what you named your column.

Your column has a hyphen between "At" and "Risk" - so it's actually named "At-Risk".

So if you wanted to utilize my formula above with that spelling, all you need to do is update the formula to this:

=countifs([At-Risk]:[At-Risk],true,[Team Owner]:[Team Owner],"CLBSD")

Alternatively, you could update the formula to utilize the Status column instead:

=countifs([At-Risk]:[At-Risk],"At-Risk",[Team Owner]:[Team Owner],"CLBSD")

Make sense?

Let me know if that works for you!

‎

Brett Wyrick

Do you have a dedicated "At Risk" column, like a flag? Or a Column that simply says "At Risk"?

I don't know the names of your columns, but if I had to take a stab at it, I'd use something like this. My example is if you have an "At Risk" flag, and if "Brett Wyrick" is the name of your Team Owner.

=countifs([At Risk]:[At Risk],true,[Team Owner]:[Team Owner],"Brett Wyrick")

For ease of use, I'd add this formula to a "Summary Field", which you can get to by clicking this icon on the right side of the sheet:

Let me know if this solution works!

ashley.elma

I was trying do it off the status column but that didn't appear to work so I added a at-risk column and put the formula you recommended but its still not working

Brett Wyrick

Hey Ashley!

Your formula doesn't quite match up with what you named your column.

Your column has a hyphen between "At" and "Risk" - so it's actually named "At-Risk".

So if you wanted to utilize my formula above with that spelling, all you need to do is update the formula to this:

=countifs([At-Risk]:[At-Risk],true,[Team Owner]:[Team Owner],"CLBSD")

Alternatively, you could update the formula to utilize the Status column instead:

=countifs([At-Risk]:[At-Risk],"At-Risk",[Team Owner]:[Team Owner],"CLBSD")

Make sense?

Let me know if that works for you!

‎

ashley.elma

That worked! thank you!

Brett Wyrick

That's great! Can you mark this as "answered" by clicking the Yes on this comment? Helps others find similar solutions when they're searching!

Thanks!