Sumifs to count color symbols


I have a spreadsheet where I am tracking initiatives by team for each month and there is a color assigned to that initiative. For each month I assign these colors. I have a total of 12 columns. Green for on track, Yellow for at-risk, Red for breached, and Gray for not started. I really wished I could add one more for Complete but that is not the question now.

I am trying to add all greens against the teams so the teams. For example, HR had initiatives to update employee data and update time management software and the first initiative is on track and the other one has breached. So I have a total count of 1 against green and 1 against red.

I will appreciate any help.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!