Forum Discussion
Gabriela Saenz
Oct 12, 2018Copper Contributor
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
Sort By
- BobOrrellIron 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