Percentage function needed
 

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


--
scyce
------------------------------------------------------------------------
scyce's Profile: http://www.excelforum.com/member.php...o&userid=34053
View this thread: http://www.excelforum.com/showthread...hreadid=538139

Percentage function needed
 

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