Tallying Votes in Excel

  • Thread starter Thread starter Noah Negrin
  • Start date Start date
N

Noah Negrin

When conducting a vote and tallying results in excel, the two responses are
‘YES’ and ‘NO’. If 100 people are going to vote, and it requires 60 ‘YES’
responses for the vote to pass, how can I program excel to count the ‘YES’
votes and do something when it hits 60? If I could have it highlight the
cell below the voting results Green or something, that would be perfect.
 
This macro will do it
Sub stopwhen()
mc = "f"
lr = Cells(Rows.Count, mc).End(xlUp).Row
For Each c In Range(Cells(2, mc), Cells(lr, mc))
If ucase(c) = "YES" Then myc = myc + 1
If myc = 60 Then
MsgBox c.Address & "=" & myc
c.Offset(1).Interior.ColorIndex = 36
Exit For
End If
Next
End Sub
 
Don,

Unfortunately I am not very familiar with Macros. Is there a formula I
could input into a cell to count up the YES votes? Or could you explain to
me in as basic terms as possible how to input that Macro?

Thanks very much!
 
I should give more info. If data in f2 down, put this formula in g2 and copy
down.
=IF(COUNTIF($F$2:$F2,"y")>6,"",COUNTIF($F$2:$F2,"y"))
 
In cell c1

=COUNTIF(B1:B100,"Yes")

In cell c2

=if(C1>=60,do condition a,do nothing)


"Noah Negrin"
wrote:
 
Back
Top