I have

A1 to A6: NY, TX, CA, TX, NY, CA

B1 to B6: 1, 0, 0, 1, 1,1

I would like to track the statistical showing for each state. ie end results should be:

NY 2

TX 1

CA 1

This is what I Have done so fare.

Define: Location as A1:A6

Define: Headcount as B1:B6

Cell C1 contains:

Count(IF(Location="NY",Headcount,0))

I entered by "shift+control+enter"

This is what shows up in C1:

{Count(IF(Location="NY",Headcount,0))}

I keep on getting 0 for the the result of C1?? The answer should be 2.

Thanks for your help!