I am trying to analyze a list of baseball teams and the number of players
they have at each position. For example, I have two columns that I am
working with: column 1 is the team name, and column 2 is the position. So,
my datasheet looks like this:
Team Position
Bears 1B
Bears 1B
Bears 1B
Bears 2B
Bears SS
Lions 1B
Lions Catcher
Lions SS
Lions P

I want to count how many times the string "1B" appears for the team,
"Bears". I'm using the formula example from Office Online
(http://office.microsoft.com/en-us/as...561181033.aspx):
=SUM(IF(A2:A9="Bears",IF(B2:B9="1B",1,0)))
But it returns a value of zero... as you can see, it should return a value
of "3". Any thoughts?

Jimmy