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

[Known]

Hi All,

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

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 ****tail has been voted for e.g.:

****tail A
****tail C
****tail B
****tail B
****tail A
****tail 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?!

 

[VoG]

Try

=SUMIF(C1:C1500,G2)

 

[Domski]

Hi,

Try:

=COUNTIF(C1:C1500,G2)

Dom

 

[Special-K99]

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

 

[pcc]

use apivot table.
****tail = row field
count of ****ttail = data field

there is a wizard to help if you don't know about pivot tables
(under 'data' menu)

 

[excelvideotips]

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

=COUNTIF(B10:B15,"****tail A")

 

[Known]

Thanks for your help, will give it a shot