Percentage function needed

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
 
B

Bondi

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
 
Top