COUNTIFS

Hi, I have this formula below but its picking up everything that contains small fixes. We have small fixes, small fixes delivered and small fixes closed but I would only like to find results that are small fixes only. Can you help? Here is the formula I have

=COUNTIFS({TL}, FIND(Metric@row , @cell ) > 0, {IS}, CONTAINS("Small Fixes", @cell ))

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

Eric_

Your formula works normally. "Small Fixes delivered" matches the condition "Contains Small Fixes". Your condition should be strict, not contains but equals to.

Karl86

@Eric_ thanks what should I replace contain with? =?

Eric_

I'm not very comfortable answering without seeing your sheets, but I guess you could replace

{IS}, CONTAINS("Small Fixes", @cell )

{IS}, ="Small Fixes"

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.