COUNTIF CONTAINS HELP

KristiTRUSD

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!

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

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