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
-
-
@Paul Newcome Like so- I believe it's incorrect because it's giving me 424 (this time) which makes the total 902. The total is supposed to be 733- I can show the formulas for the other two if you'd like as well!
-
Yeah. That formula is correct. What are the other formulas?
-
I'm just not sure why it's giving me 424 when my total should be 255 here.
-
Should that last one be greater than or equal to 2001 instead of less than or equal to?
-
I didn't even notice that error. I fixed it, my bad! Silly mistake. Thanks for pointing it out, Paul! π
Help Article Resources
Categories
Check out the Formula Handbook template!