Forum Discussion
My Percentage of total sales is not 100 - Why?
I have 20 categories of Sales Revenue in Column A, the total revenue for each category is in column B, the % of a category, as it relates to the total categories is in column C but the Total Percenta...
I'm new to this and have a similar issue. I summed my percentage columns and reached 100% in two of the three columns in my datasheet, however, the third is 3.26% over. I've checked my formulas, my formatting and my arithmetic. What could be my issue?
Metts518 : there could be several different causes. You give no indication of what kind of data you're dealing with, whether one of more of the columns involves some rounding to nearest whole digit or two decimal places or whatever. Rounding, which most of us think of as "rounding up" could be the cause of your issue. I just recently (in another thread in this forum) learned of what's called "Bankers' Rounding," a method to minimize what you may be experiencing.