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?
