How do I show the sum of multiple ranges in one cell? How do I show the sum of multiple ranges in one cell? I want to add the sum of C5:C25 to the sum of G5:G25 and divide the answer by 14.
=(SUM(C5:C25)+SUM(G5:G25))/14


SUM function takes a range. + operator adds the results. / operator divides.