At least, I believe nesting will be required.

On Worksheet 1 (titled Log) I have a Date column covering 1997 through 2005
and a Unit column with seven different units represented throughout.

On Worksheet 2 (titled Synopsis) I want a formula to reflect the number of
entries for Unit X in 1997.

Thanks in advance!