need formula to add cell sums by color of cell

B

Brucet

I am working in a imported file that I can't change the format
but I need to pull out the values of different cells so if I change the
color
of the cell, I want to total the value of lets say blue. Is that
possable

Thanks
Bruce
 
Top