COUNTIFS for cell value between 2 limits

Hi everyone,

I'm using the appended formula to count the number of times the cell values in a column fall between two limits.

=COUNTIFS({Summary sheet Family}, "Cups", {summary sheet install phase}, "Storage", {summary sheet Storage duration}, >=[Metric1,]26 < [Metric2]26)

The above formula works without error, but does not calculate correctly - it seems it uses the 2nd part of the formula only (< [Metric2]26))

I can use a helper column but does anyone know if it is possible to use "AND" so that both conditions can be used?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!