Forum Discussion
What is this Madness? Weird Average and Sum results
HelloLYorkToenniges,
You are comparing two different calculations, so the results will not match.
The blue value is the average of the row-by-row divisions, which gives each row equal weight.
The green value is calculated by dividing the sum of one column by the sum of the other, which creates a weighted result.
These are not mathematically equivalent and will only match if all denominators are the same.
The difference you are seeing is expected behavior in Excel, not an error.
I'll be honest, I'm really embarrassed. My coworker pointed out what I was missing. Basic PEMDAS. I knew the issue had to be me, my mind was just not seeing what math I was really doing.
1/3 +2/6 +5/8 <> (1+2+5)/(3+6+8) if I saw this I'd be like, yeah, duh. So embarrassing.