How to summarise the number of coloured cells?

[LH8568]

Please fid attached example sheet.

I have the sheet attached, it is a system which monitors how close a product is to its expiry date by a red amber and green system. There are multiple products with various different locations and lot numbers. I need a summary sheet on a different tab which says for product X, what percent of colour is at todays date for a 6 week period. So for the example attached it would be around 40% green. Then when the green disappears as time progresses it would switch to some green and some amber etc.