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.



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


How about




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