Why is my COUNTIFS formula counting more items than necessary?

Carolina Rivera
edited 07/17/20 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!