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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks