Tallying Votes in Excel

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.
 
D

Don Guillett

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
 
N

Noah Negrin

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!
 
D

Don Guillett

Formula in helper column
=IF(COUNTIF($F$2:$F8,"y")>6,"",COUNTIF($F$2:$F8,"y"))
 
D

Don Guillett

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"))
 
B

Brad

In cell c1

=COUNTIF(B1:B100,"Yes")

In cell c2

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


"Noah Negrin"
wrote:
 
Top