Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
27
Views
Topic starter
In the attached spreadsheet I defined a calculated field for the bonus report of the bonus
In the calculation I have activated an IF function
The answer received every month is good,
But overall there is a problem -
Instead of summing up the number 116,277
He sums up the number 250,104
Why??
THANK YOU!
Posted : 21/07/2019 7:58 pm
Hello,
in the bottom section of this blog you find an explanation of this issue.
”Sometimes the totals will be wonky - Totals aren’t actually totals; every cell you see in the values area for a Calculated Field is the result of the formula. It’s like having the same formula in every cell in the column irrespective of whether the row is a totals row or not.”
Posted : 22/07/2019 1:35 am