Hi,
I have a spreadsheet which tracks SLA performance and there is currently a column with a target to hit, followed by another column that has the actuals in there. On the actual column I have added in some conditional formatting that will change the cell colour depending on whether the actuals are either in SLA, out of SLA or are equal to the target.
I would to add another column which provides an aggregated count of how many agents are either in or out of SLA. I know that a formula can't count cell colours and would like to know the best way to give this aggregated view.
I have attached a spreadsheet that will hopefully help.
