countif cells with conditional formatting

[mlmoyer]

I think I know the answer from perusing other threads, but just in case I misread ...

We track monthly performance against a number of service levels. Those service levels that miss their get colored RED with conditional formatting. The formulas vary from service level to service level (e.g. some may have to be ">=" the target, others are "<=" the target.)

The various service levels are in column A, the target in column B, and the actual result for each month in columns C thru N (Jan - Dec).

Above (or below) all the service levels for each month I want to show the total service levels for that month count which are RED. Is that possible?

Thanks so much.

Mark

 

[Weaver]

What you need to do is count the cells that meet the condition used to turn the cells red. For instance, if it was any value above 10 that turned the cell red, then count the number of values above 10.

As far as I know, you can't count regular colours (unless you use a macro) let alone conditional ones.

HTH