Countifs formula

Kamya Pamnani

Hi,

I want count where date column is not blank and country is Australia. Example is below where Smartsheet completion is not blank and country is Australia so need to calculate count of dates.

How to write Countifs formula with not blank as criteria. Have tried following formula but it shows error:

=countifs([Smartsheet Completion]:[Smartsheet Completion], not blank, Country:Country, "Australia")

Andrée Starå

Hi @Kamya Pamnani

I hope you're well and safe!

Try something like this.

=countifs([Smartsheet Completion]:[Smartsheet Completion],<>"", Country:Country, "Australia")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Kamya Pamnani

I hope you're well and safe!

Try something like this.

=countifs([Smartsheet Completion]:[Smartsheet Completion],<>"", Country:Country, "Australia")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kamya Pamnani

Thanks Andre, It worked.

Andrée Starå

@Kamya Pamnani

Excellent!

Happy to help!

The <>"" is the same as a NOT ISBLANK combination.