Why is my COUNTIFS formula counting more items than necessary?

Carolina Rivera

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

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?