How to add few texts/words on countif(s) formula

Grace

Hi, can someone help me on the correct formula that I should use? I wanted to get the number of projects based on their status however the countif formula that I am trying to use doesn't work in Smarsheet but works in Excel.

Below is the formula I used in Excel that worked:

=COUNTIFS(B3:B11,"*contract for*",C3:C11,"=active",D3:D11,"delayed")

 

I tried an alternative solution by using the project owner names but I only want to count the cells that are not blank.

Alternative formula I used in Smartsheet:

=COUNTIF([Project Owner]:[Project Owner], "<>", Status:Status, "complete")

 

Please need your comments and suggestions.

Many thanks in advance,

Grace

Chris McKay

Hi Grace,

Smartsheet's search operators are less than perfect and nowhere near what you're used to in Excel.

Will this do what you need?

=COUNTIFS([Project Owner]:[Project Owner], NOT(ISBLANK(@cell)), Status:Status, "Complete")

Grace

Hi Chris,

The formula worked! Thanks a lot for your help. 

Cheers,

Grace

Chris McKay

Happy I could help out Grace.