Hi,
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!
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!