I have used the average button under the autosum drop down to get averages. Now I need to take those averages, and divide each number by 6, and make a new chart but I cannot copy paste the averages because they are formulas not numbers. I get #REF when i try to paste the averages in a new cell.
Solved by S. Q. in 27 mins