Percentage formula in excel

[Trevea]

I have 4 columns which I have set up with a formula to calculate percentage.
The 4 column formulas should equal 100% but they equal 106%. Can you help?

 

[Fred Smith]

Yes, if you tell us what formula and data you have.

Regards,
Fred

 

[Trevea]

I have 4 columns which I have set up with a formula to calculate percentage.
The 4 column formulas should equal 100% but they equal 106%. Can you help?

Column Totals 971,978.64 4,050.00 734,810.51 247,068.13
%from formulas 1.86% 0.42% 75.92%
25.53%
formulas e38/d38 f38/3/38
G38/(e38-f38) h38/(e38-f38)

 

[Trevea]

Column Totals 971,978.64 4,050.00 734,810.51 247,068.13
%from formulas 1.86% 0.42% 75.92%
25.53%
formulas e38/d38 f38/3/38
G38/(e38-f38) h38/(e38-f38)

The percentage totals are now 103.74%

 

[Trevea]

Column Totals
d38 52,301,407,62
e38 971,978.64
f38 4050.00
g38 734,810.51
h38 247,068.13

Formulas
e38/d38
f38/e38
g38/(e38-f38)
h38/(e38-f38)
f38/e38

 

[Fred Smith]

Why do you expect the percentages to add to 100%? You're not dividing by the
sum of the numbers.

If you're want to calculate the percentage of the total, first make sure
you're dividing by the total.

Regards,
Fred.