I am using a countif formula [=COUNTIF('Student Surveys'!D151:D168, "w")] . This formula counts the number of times there is a "W" in the designated cells but I also need to know what percent of all the cells have a "W". What formula can I add for this? Or should I be using a different formula all together?
