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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Numbers 26
Same formula one not calculating properly? 2
Vlookup or similar 7
Two Formula Questions 2
How to list cells from two sheets that has different values in theirneighboring column? 8
formula to count matching days between two date ranges (for largelist of names) 2
list items from one table in another table based on value in first table 2
Countif, index and match 2

Back
Top