excellll
•
3 Oct 2008, 22:10
•
Journals
Hey,
I'm working with excel, I have a column with 2 possible answers (yes/no).
I would like excel to only count the "yes" answers and to calculate what % it represents overall (total=30).
Thanks
I'm working with excel, I have a column with 2 possible answers (yes/no).
I would like excel to only count the "yes" answers and to calculate what % it represents overall (total=30).
Thanks
=(COUNTIF(A1:A30,"yes"))/(COUNTIF(A1:A30,"*"))*100
Or something similar
Right back to the wine