Countifs formula



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")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!