Count between ranges

Jason H

Reaching out to see if my formula, which seems to be working, is the correct way to COUNT between two ranges.

In my example - I want to count a category name AND only if the % Complete range is between 25% - 49%

FORMULA

=COUNTIFS({Function}, "Asset Protection", {Percent}, >0.25, {Percent}, <=0.49)

As mentioned this seems to be pulling data back but I'm sure there is a much better formula.

Thanks - J

Find more posts tagged with

Formulas

Accepted answers

All comments

John Jonassen

This is the correct function and use for your need, @Jason H. Well done!

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