Countifs formula

Options

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



Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!