Total the numbers in the red cells. Average the cells with green font. While I have previously shown how to do this with VBA, it is now possible to quickly do this using a new add-in called DOSE for Excel.
Use coupon code MrExcel25 to save 25% on DOSE. Shop at https://MRX.CL/getdose