COUNTIFS for cell value between 2 limits

Tim Dowden

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?

thanks

Tim

Bassam Khalil

Hi @Tim Dowden 

Hope you are fine, please try the following formula:

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

Bassam Khalil

Hi @Tim Dowden 

Hope you are fine, please try the following formula:

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

Tim Dowden

Thanks for your prompt reply Bassam, your solution worked perfectly

cheers

Tim

Bassam Khalil

@Tim Dowden

Excellent, i will be happy to help you any time.