Soldato
I'm getting an incorrect result when using =SUM in Google Sheets. Any idea why?
It's really basic. The formula is =SUM((C2:C63)/62), so it's just an average with the C column simply being numbers. However the output of the formula is 4.84% but the correct answer is 4.629032% (nowhere near the result even if rounded up).
The column totals correctly as 287 when using =SUM(C2:C63), and using =SUM([that cell]/62) works as well.
I'm stumped, and it's making me doubt/check all the other formulas which isn't particularly productive.
It's really basic. The formula is =SUM((C2:C63)/62), so it's just an average with the C column simply being numbers. However the output of the formula is 4.84% but the correct answer is 4.629032% (nowhere near the result even if rounded up).
The column totals correctly as 287 when using =SUM(C2:C63), and using =SUM([that cell]/62) works as well.
I'm stumped, and it's making me doubt/check all the other formulas which isn't particularly productive.