Forum Discussion
CountIF Using Text (Specific Words)
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
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)
