COUNTIF CONTAINS HELP

Options

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!

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Answers

  • KristiTRUSD
    KristiTRUSD ✭✭✭
    Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!