COUNTIF CONTAINS HELP

Hello,

I am trying to get a count of how many Greenwaste projects are completed on the sheet.

Here is my fx: =COUNTIFS([District Site]1:[District Site]219, "Greenwaste", Status1:Status219, ("Completed"))

^^^ is returning a zero right now, it should count at least 3 as completed. Can someone let me know what I am doing wrong? Your help is appreciated very much!

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi @KristiTRUSD

I'm glad you were able to figure it out! Yes, if you type a criteria "in quotes" the formula will only look for an exact match.

You could use CONTAINS if you're looking for any cell that contains a certain value.

You may also want to remove out the Row Numbers from your [Column References] so that it will search your entire sheet as new rows are added:

=COUNTIFS([District Site]:[District Site], "Greenwaste", Status:Status, "Completed")

Cheers,

Genevieve

All comments

KristiTRUSD

Never mind, I figured it out. I wasn't putting the entire statement I wanted SS to search for.

Genevieve P.

Hi @KristiTRUSD

I'm glad you were able to figure it out! Yes, if you type a criteria "in quotes" the formula will only look for an exact match.

You could use CONTAINS if you're looking for any cell that contains a certain value.

You may also want to remove out the Row Numbers from your [Column References] so that it will search your entire sheet as new rows are added:

=COUNTIFS([District Site]:[District Site], "Greenwaste", Status:Status, "Completed")

Cheers,

Genevieve

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.