COUNTIF formula between date range

anr1996

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!

Find more posts tagged with

Conditional Formatting

help

Countif

dates

Accepted answers

All comments

Paul Newcome

Can you show how you are trying to add it?

anr1996

@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!

Paul Newcome

Yeah. That formula is correct. What are the other formulas?

anr1996

https://community.smartsheet.com/discussion/comment/470290#Comment_470290

I'm just not sure why it's giving me 424 when my total should be 255 here.

Paul Newcome

Should that last one be greater than or equal to 2001 instead of less than or equal to?

anr1996

https://community.smartsheet.com/discussion/comment/470314#Comment_470314

I didn't even notice that error. I fixed it, my bad! Silly mistake. Thanks for pointing it out, Paul! 😊

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.