Forum Discussion
Heather Surrency
Jan 31, 2017Copper Contributor
countif formula question
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?
- Detlef_LewinSilver Contributor
Hello Heather
=COUNTIF('Student Surveys'!D151:D168,"w")/ROWS('Student Surveys'!D151:D168)