Counting # of rows that match a number range

I am trying to create a sheet summary formula to count the number of projects that are within a number range (# of days out or past). I am not sure what function or formula to use but I created a formula like this that isnt working: =COUNTIFS([# of days to Finish Date]:[# of days to Finish Date],=>0,([# of days to Finish Date]:[# of days to Finish Date],=<30))

I want to create a formula that will count # of projects that are between 0-30 days out and 31-60 days out.

Any ideas?

Find more posts tagged with

Accepted answers

Jeff Reisman

First, you need to have your operators in proper order. It's always "greater than or equal to" or "less than or equal to". Next, use the AND function to give two criteria for the same range that must be true.

Try this:

=COUNTIFS([# of days to Finish Date]:[# of days to Finish Date], AND(@cell >=0, @cell <=30))

and

=COUNTIFS([# of days to Finish Date]:[# of days to Finish Date], AND(@cell >=31, @cell <=60))

All comments

Jeff Reisman

Try this:

=COUNTIFS([# of days to Finish Date]:[# of days to Finish Date], AND(@cell >=0, @cell <=30))

and

=COUNTIFS([# of days to Finish Date]:[# of days to Finish Date], AND(@cell >=31, @cell <=60))

Gabe Tarin

@Jeff Reisman Thanks again Jeff! That worked perfectly.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.