My Percentage of total sales is not 100 - Why?

[Nathalie135]

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 Percentage is over 100% when I total all the percentages, what am I missing?

		Amount	% of Sales
Backup & Recover-Desktop Suppor		70,808.50	2.2%
Barracuda Back Up - Cloud to Cloud		11,220.00	0.35%
Barracuda ESS - Security Edition		$51,508.57	1.62%
Barracuda Sentinel		20,093.52	0.63%
Carrier Management / NOC Support Services		$239,618.99	7.54%
Cust Support Srvs/Provisioning/vCIO Svcs		$98,514.00	3.10%
Field Services Support-Single		$1,447,941.00	45.56%
FTE Tech		159,227.50	5.01%
Hardware Lease Revenue		11,114.22	0.35%
Help Desk Services		1,604,649.85	50.49%
IH-New User_Laptop Setup		$230,523.19	7.25%
IH-Remote Work Support Services		60,172.85	1.89%
MRR - Data Services/Ticket Overage		$40,057.00	1.26%
Network & Security Hardware		$985,825.90	31.02%
Network Monitoring Service-Devices		153,696.60	4.84%
NRR - Carrier Management / NOC Services		11,245.00	0.35%
NRR - ESS Email Security Services		28,865.00	0.91%
NRR - Help Desk		46,500.00	1.46%
NRR - Migration Implementation		98,595.00	3.10%
NRR - Monitoring Services		15,000.00	0.47%
Remote Server Monitoring		102,455.03	3.22%
Remote Work/Sharepoint Migration		$84,026.55	2.64%
Shipping & Delivery Fee		49,970.63	1.57%
Software/Licenses		491,422.97	15.46%
TOTAL		$3,178,015.20	192.35%

[#2]

@Nathalie135 

	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

[#3]

Thank you so much,. I really appreciate your help and response.

[#4]

@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.

[#5]

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

[#6]

@Nathalie135.... FYI, "cell formatting" cannot explain the difference between 3.2 million versus 6.1 million.

A more likely explanation is:  the summation cell was not recalculated.  And beware: that might still be an ongoing issue, remedied on a one-time basis because the changes that you made forced a recalculation.

In the future, attach a example Excel file that demonstrates the problem so that we can see your formulas, the original data, and the settings of workbook-specific options.

[#7]

Will do, thank you, I will keep an eye out for that and send a bit more detail next time. Thanks again :)