simple % formula

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
[email protected]HIS


"John" <[email protected]> wrote in message
news:[email protected]...
>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
>
>