Forum Discussion
sum formular error
how come some time we sue sum to calculate the total, some tab shown as error?
zh-sum_error If you refer to the green triangle in the top left corner of the cell with 108, that just a sign to alert you that something may be wrong. Excel does background error checking and often guesses that you may have done something wrong even when you have not. Perhaps the formula looks different from those in neighboring cells. If that is intentional, ignore the 'warning'. What do see when you click on the cell with 108 and hover the mouse pointer over the triangle that appears?
Riny_van_Eekelen thank you for the help! yes, I am referring to the green triangle, the formular is total same as neighboring as I copy the formular from neighboring, how to remove the green triangle if there not an error?
zh-sum_error If you want to get rid of the warnings you can uncheck the box where it says Enable background error checking in File, Options, Formulas:
