Formula to count fields that are not blank

edited 12/09/19 in Formulas and Functions

I am just getting familiar with smartsheets and am having a problem convert a spreadsheet that contains a formula that I really need. This formula currently works well in Excel to count cells that contain dates so if any cells are blank it won't count the cell. This is the formula that works in Excel =COUNTIF(L4:AO4,">2016"), does anyone had any idea how to customize such a formula to work in a smartsheet. Thanks in advance for any feedback! :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!