COUNTIF formula between date range

I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet.

This is the sheet with all my data (of course, just a small example)

And this is the range within which I'm trying to work. For 1976-2000, the formula I have is

=COUNTIFS({Game Design Range 2}, >=1976), but trying to add

{Game Design Range 2}, <=2000

as the second criterion gives me #UNPARSABLE. Anyone have any tips/way to get what I'm looking for? Thanks in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!