Forum Discussion
WanderingSquid
Jan 25, 2020Copper Contributor
AVERAGE not showing the same result
Hello All, New to the forum and wondering if someone can explain a problem for me please. I have 13 cells that i need to average. When i took on the worksheet, it had a formula using SUM to get...
SergeiBaklan
Jan 25, 2020Diamond Contributor
I guess you have empty cells in the range - AVERAGE ignores them, but SUM considers as zero.