Percentages...

  • Thread starter Thread starter Louie Warren
  • Start date Start date
L

Louie Warren

I have a column in a spreadsheet that contains the first
name of people involved with a particular aspect of a
project...

Thing1 Steve
Thine2 Louie
Thing3 Perry
Thing4 Jeff

....

I want to be able to say what percentage of the total
number of "things" each name belongs to. I had thought of
setting up 3 more columns and having something like, If B1
= Steve then put an X in this column, otherwise leave it
blank. I would then calculate the totals and figure out
the percentage. Is there a way to do this with just the
two columns and some function? Thanx!

L
 
Hi
try something like the following
=SUMPRODUCT(--(A1:A100="Thing1"),--(B1:B100="Steve"))/COUNTIF(A1:A100,"
Thing1")
and format the resulting cell as percentage.

In addition you may consider using a pivot table to create a report for
all topics/names
 
The "things" don't weigh into the formula. Of the total
of 100 "things", Steve is assigned to X, Jeff is assigned
to Y, and Perry is assigned to Z... that's what I'm going
for... X is a percentage of the total, as is Y, and Z.
 
Back
Top