Percentage function needed

  • Thread starter Thread starter scyce
  • Start date Start date
S

scyce

I have an array of numbers (subset below). I would like a formula that
would tell me what percentage of the total of this array each of the
numbers are.

359.45 (i.e. 11%)
348.90 11%
12.10 2%
11.30
319.75
320.35
166.50
11.30
241.70
 
Hi scyce,

Asuming your data starts in A1 you could put this in to B2 and drag
down:

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

Regards,
Bondi
 

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

Back
Top