I have been searching everywhere. I made a drop down box that says yes and no. I need yes to equal 1 and populate the number of yes's in one column. Can someone please help!
I have been searching everywhere. I made a drop down box that says yes and no. I need yes to equal 1 and populate the number of yes's in one column. Can someone please help!
goose1,
It sounds like you want to count the number of "Yes" or "No" entries in a column (depending on what you have selected from your drop down list) and display the total.
For your spreadsheet, i'm imagining the following:
Questions in column A
Yes/No entries in column B
Row 1 has headers
The drop-down list is a cell containing a validation list. That drop-down list is in cell C2
Using that setup, you could put the following formula in cell D2:
=IF(C2="","",COUNTIF(B:B,C2))
If this is not correct, or you are looking for something different, please provide more information and/or a sample workbook so that we can better help you.
~tigeravatar
You can just use COUNTIF
e.g.
=COUNTIF(A1:A100,"Yes")
This counts the number of Yes's in A1:A100
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks