Hi,

What I'm trying to do is get a count of cells from one column based on
cells that do not contain specific text in another column, i.e.;

A B
1 at Laurel W
2 Silver Spring L
3 Wheaton W
4 at Rockville W
5 at Bethesda L
6 Olney L
7 Gaithersburg W
8 Takoma Park W
9 at Chevy Chase W

I am trying to get a count of W's and L's based on home games, without
the "at". I have a formula for away games but can't figure out the
home games.

Any help would be greatly appreciated.

Thanks, DB