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
-
Can you show how you are trying to add it?
-
@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! 😊
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!