category %

[pytelium]

category %

--------------------------------------------------------------------------------

I have 3 columns as below

Joe Bloggs IN 3
Joe Bloggs OUT 4
Joe Bloggs SAME 2
Joe Bloggs BLANK 7
Mary Loo IN 6
Mary Loo OUT 11
Mary Loo SAME 5

I wish to make a 4th column with % of total for each person e.g for Joe
Bloggs in D1 will be 3/16 expressed as a %

What formula will I use to fill in the column

 

[Ron Coderre]

Put this formula in D1 and copy down:
=C1/SUMIF($A$1:$A$100,A1,$C$1:$C$100)

Does that help?

Regards,
Ron

 

[pytelium]

Thanks Ron,it works