Forum Discussion
What is this Madness? Weird Average and Sum results
What is this devil math? What am I missing? The darker green value and blue value should match. I checked for truncated decimal values, even rebuilt the sample to ensure nothing was weird abou...
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.