Count of Cell Color for Each ID

[chandramouliarun]

Hi All,

I am trying to accomplish the following : Count the cell color for each ID for each of ID'S as below: Can you please let me know how to achieve the same..

I have attached the sample workbook on the same on what I want....Can you please let me know as to how to go about it...


Thanks,
Aruin

[Sam Capricci]

to count colored cells you need to use VBA. If however you have a formula that you use to "conditionally format" the cells you can use the same formula to count.
Lastly, this is a formula that I came up with that keys on the similarities between your colored cells that appears to give the same results you noted...
=SUMPRODUCT(($A$2:$A$12=A2)*($B$2:$B$12={"chat","rep"})) maybe that is all you need.

EDIT: and adjust the ranges as your data requires.