I need the percentage of objects used in a drop-down box

  • Thread starter Thread starter John C
  • Start date Start date
J

John C

I'm creating a spreadsheet of the different sites that I visit. There are 12
different areas that I have listed in a drop-down box. since there are
multiple sites within a given area, they will show up on the sheet multiple
times. What I need is to show the percentage of the 12 different areas I
have visited as a running calculation. Example; NYC (2 times) Portland (3
times) Atlanta (1 time) Chicago (4 times). I made 10 visits, showing 4 areas
10 times and actually visited 33.33% of my areas
 
Hi John,
Try
=COUNTIF($A:$A,C2)
Where column A is where you enter your data and C2 is in your case the area
i.e. NYC
If you are not using excel 2007 replace the above formula with

=COUNTIF($A1:$A1000,C2)
 
Hi,

I'm not entirely clear on what you are asking. Show us a sample layout.

Here is my guess - you have a list of all the places you visited in A1:A100,
in B1 you have a Data Validation drop down listing the unique entries in
column A. If that is the case then in C1 enter the following formula

=COUNTIF(A1:A100,B1)/COUNTA(A1:A100)

and format as a percent.
 
Back
Top