Find the average of a row by color

Hi there,

I hoping for some help with my problem. I am looking for a quick way to find the average of a row of numbers by there color.

I need to find the average of only the green and red cells (ignoring the white and blue cells) without having to select each cell individually.

Any help would be greatly appreciated.

Thanks

David