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?

thanks

Tim

Find more posts tagged with

Accepted answers

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))

All comments

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.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.