Forum Discussion

Gabriela Saenz's avatar
Gabriela Saenz
Copper Contributor
Oct 12, 2018

I´m working with a poll and I need to sum all the Yes on my worksheet

How can I sum all the "Yes" and the "no" of the answers of a poll in a worksheet

 

1 Reply

  • BobOrrell's avatar
    BobOrrell
    Iron Contributor

    You can use Countif as follows

    =COUNTIF(G9:G14,"yes")
    =COUNTIF(G9:G14,"no")

    Where G9:G14 is the range you want to evaluate

Resources