simple % formula

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a column of different numbers - whats the formula to return what % of
the range is a certain number....?

So it could read...
% at '5' ... 15%
% at '4' ... 68%

etc...


John
 
John

If I understand you, imagine your range is A1:A12, then in B1 enter

=A1/SUM($A$1:$A$12)

and copy down to B12. The results now in B1:B12 will add to 100%

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top