I'm having a problem with the sumif function...I'm using it to calculate averages for NBA teams and it's working fine for all teams except the Boston Celtics. For some reason sumif won't recognize the text "Boston Celtics" as the criteria. Any ideas? Thanks.