Thanks:  0
Likes:  0

# Thread: How Do I count Votes For a particular perseon in excel?

1. ## How Do I count Votes For a particular perseon in excel?

Hi All,

We have recently run a competition on our website which requires the user to vote for one of 17 cocktails.

Votes have come in thick and fast (1200 at the last count)

The trouble is our mechanic does not count the votes, only showing a list of which cocktail has been voted for e.g.:

Cocktail A
Cocktail C
Cocktail B
Cocktail B
Cocktail A
Cocktail A

Is there a way of taking this table into excell and having it count how many A's, B's and C's there are?

I tried looking at =SUMPRODUCT(C1:C1500=G2) where G2 is the name of Cokctail A.

Can anyone help this poor novice Excel user?!

2. ## Re: How Do I count Votes For a particular perseon in excel?

Try

=SUMIF(C1:C1500,G2)

3. ## Re: How Do I count Votes For a particular perseon in excel?

Hi,

Try:

=COUNTIF(C1:C1500,G2)

Dom

4. ## Re: How Do I count Votes For a particular perseon in excel?

=sumproduct(--(c\$1:c\$1500=g2))

5. ## Re: How Do I count Votes For a particular perseon in excel?

use apivot table.
cocktail = row field
count of cockttail = data field

there is a wizard to help if you don't know about pivot tables

6. ## Re: How Do I count Votes For a particular perseon in excel?

You can use a pivot table (explained in www.ExcelVideoTips.com) or the Countif function

=COUNTIF(B10:B15,"Cocktail A")

7. ## Re: How Do I count Votes For a particular perseon in excel?

Thanks for your help, will give it a shot