Green Spandex
New Member
- Joined
- Aug 14, 2006
- Messages
- 10
Hit the wall on what seems like a simple formula - something my brain copes with at work Mon-Fri but struggles with on the weekend!!
List of names in col A
List of years in col C
smith, 1997
jones, 1997
smith, 1997
wood, 1997
smith, 1997
smith, 1998
wood, 1998 etc.
A summary table has ALL NAMES in col U, with years (1997...2006) in row 1.
I need a formula that lists how many Smiths there was in 1997, Smiths in 1998, Jones in 1997 etc.
count all the times the smith in the summary table matches the smiths in col A AND the year in row 1 matches the year in col C....
Cheers
List of names in col A
List of years in col C
smith, 1997
jones, 1997
smith, 1997
wood, 1997
smith, 1997
smith, 1998
wood, 1998 etc.
A summary table has ALL NAMES in col U, with years (1997...2006) in row 1.
I need a formula that lists how many Smiths there was in 1997, Smiths in 1998, Jones in 1997 etc.
count all the times the smith in the summary table matches the smiths in col A AND the year in row 1 matches the year in col C....
Cheers