Colored Cell Count by Name

[RRico]

Data:
Columns with colors and non-colored (no fill) cells between Columns A through AW.

Different Agent Names within Column P representing each row as the "Agent's" row.

What Im trying to accomplish:
If any color within Columns A through AW, display Agent Name within a count value as to how many times color appeared for an Agent.

This data can appear in two separate cells within the sheet or in another sheet altogether.

Thank you to ahead of time to anyone who knows how to do this!

Rick

 

[RRico]

Replying with a more clear version to hopefully help?

Data:
Columns with colors and non-colored (no fill) cells between Columns A through AW.

Different Agent Names within Column P representing each row as the "Agent's" row.

What I'm trying to accomplish:
IF any color (cell fill color, not font color) exists within Columns A through AW, display Agent Name (found in column P) with a count value to show how many times a cell color appeared for an Agent.

This data can appear in two separate cells within the sheet or in another sheet altogether.

Thank you to ahead of time to anyone who knows how to do this!

Rick