category %

  • Thread starter Thread starter pytelium
  • Start date Start date
P

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
 
Put this formula in D1 and copy down:
=C1/SUMIF($A$1:$A$100,A1,$C$1:$C$100)

Does that help?

Regards,
Ron
 
Back
Top