Why is my COUNTIFS formula counting more items than necessary?

Hi all!

I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days):

=COUNTIFS({Age Grouping}, "desired amount of days")

The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns the number of items for all three criteria. For example, there are 2 (91-180 days) items, 3 (181-270 days) items and 7 (>270 days) items; but the formula returns 12 items for 270 days. Does anyone know why this may be?

Thanks in advance,

Carolina Rivera

Find more posts tagged with

Sheets

Formulas

Support

Solution Center

Cell linking

Accepted answers

All comments

Paul Newcome

What are the exact formulas you are using?

Carolina Rivera

Hi Paul,

The formulas I'm using are these:

=COUNTIFS({Age Grouping}, "91-180 days")

=COUNTIFS({Age Grouping}, "181-270 days")

=COUNTIFS({Age Grouping}, ">270 days")

Paul Newcome

And exactly how is the data populated in the {Age Grouping} range/what does it look like on the source sheet?

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.