I need to know the formula as to average the individual GREEN, RED, and BLUE cell data together in the TOTAL GREEN, RED, and BLUE cell at the bottom that have data in the cells. So, if there is no data in the individual cells the AVERAGE formula ignores these cells, and only averages the ones with numbers. There is not a specific 'range' for this, but the individual cells for each color that needs to be AVERAGED.
Solved by O. B. in 23 mins