Percent of total

[paulmtl]

Hi all,

How to create the formula to calculate the percentage out of the total in general format can be used all along ?

account amount percentage

11111 100 0.16
11111 200 0.34
11111 300 0.50
---------------
600

22222 200 0.25
22222 200 0.25
22222 400 0.50
--------------
800


I got the columns account , amount but need to calculate the percentage but be carefull , each time the account changes the formula of percentage should changed accordingly.

Thanks in advance,

 

[TonyJollans]

Hi paulmtl,

It may be easier than this depending on exactly what you have but if your data as posted is in columns A and B then, assuming headings in row 1, put this formula in C2 and copy down.
[blue][tt] =IF(A2="","",B2/SUMIF($A:$A,A2,$B:$B))[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[paulmtl]

Thanks Tony,
It works great.