Forum Discussion

Heather Surrency's avatar
Heather Surrency
Copper Contributor
Jan 31, 2017

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_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello Heather

     

    =COUNTIF('Student Surveys'!D151:D168,"w")/ROWS('Student Surveys'!D151:D168)

     

Resources