Forum Discussion
My Percentage of total sales is not 100 - Why?
| Amount | % of Sales | ||
| Backup & Recover-Desktop Suppor | 70,808.50 | 0.022 | 2.23% |
| Barracuda Back Up - Cloud to Cloud | 11,220.00 | 0.0035 | 0.35% |
| Barracuda ESS - Security Edition | 51,508.57 | 0.0162 | 1.62% |
| Barracuda Sentinel | 20,093.52 | 0.0063 | 0.63% |
| Carrier Management / NOC Support Services | 239,618.99 | 0.0754 | 7.54% |
| Cust Support Srvs/Provisioning/vCIO Svcs | 98,514.00 | 0.031 | 3.10% |
| Field Services Support-Single | 1,447,941.00 | 0.4556 | 45.56% |
| FTE Tech | 159,227.50 | 0.0501 | 5.01% |
| Hardware Lease Revenue | 11,114.22 | 0.0035 | 0.35% |
| Help Desk Services | 1,604,649.85 | 0.5049 | 50.49% |
| IH-New User_Laptop Setup | 230,523.19 | 0.0725 | 7.25% |
| IH-Remote Work Support Services | 60,172.85 | 0.0189 | 1.89% |
| MRR - Data Services/Ticket Overage | 40,057.00 | 0.0126 | 1.26% |
| Network & Security Hardware | 985,825.90 | 0.3102 | 31.02% |
| Network Monitoring Service-Devices | 153,696.60 | 0.0484 | 4.84% |
| NRR - Carrier Management / NOC Services | 11,245.00 | 0.0035 | 0.35% |
| NRR - ESS Email Security Services | 28,865.00 | 0.0091 | 0.91% |
| NRR - Help Desk | 46,500.00 | 0.0146 | 1.46% |
| NRR - Migration Implementation | 98,595.00 | 0.031 | 3.10% |
| NRR - Monitoring Services | 15,000.00 | 0.0047 | 0.47% |
| Remote Server Monitoring | 102,455.03 | 0.0322 | 3.22% |
| Remote Work/Sharepoint Migration | 84,026.55 | 0.0264 | 2.64% |
| Shipping & Delivery Fee | 49,970.63 | 0.0157 | 1.57% |
| Software/Licenses | 491,422.97 | 0.1546 | 15.46% |
| TOTAL | 3,178,015.20 | 1.9235 | 100.00% |
The formula I used is: =C2/$C$26
all the way down including the Total to get the 100%
don't sum the % column
cheers
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.
- Thank you so much,. I really appreciate your help and response.
Nathalie135 Not sure about your arithmetic. When I add-up the sales amounts, I come to just over 6.1 million. I.e. not 3.2 million. That's a factor 1.9235 higher. That's why you get the wrong overall percentage. And, of course, you may add up individual percentages, provided you calculated them on the correct basis.
- Thank you, I thought it looked wrong, I'm not sure what the cell formatting was doing but it was definitely doing something weird. These numbers are what I thought they should have been. When I cleared the formatting of the cells and summed it again I finally got the correct numbers (your numbers). Thanks again
