CountIF Using Text (Specific Words)

Occasional Contributor

Inside Sheet2 I have a COUNTIF formula to calculate how many times "Purple" shows up in Column G on Sheet1.

=COUNTIF(Sheet1!G:G,"Purple") 

 

But I want to divide that count by the number of records in Sheet1 (Minus the header row).  Stuck on how to get it to divide and multiply by 100 to get a %, so I know if "Purple" shows up X% of the time. There are 10 records in Sheet1 and "Purple" shows in Column G only once, the cell will equal 10%, twice 20% etc.  Does this make sense? Can anyone help? 

1 Reply

@rnelsch 

How about

 

=COUNTIF(Sheet1!G:G,"Purple")/(COUNTA(Sheet1!G:G)-1)

 

Format the cell with the formula as a percentage (no need to multiply with 100 in the formula)