Formula to count fields that are not blank

Cynthia823

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!

Paul Newcome

If you are looking for a formula to count how many dates are within a range, you would use something like this...

 

=COUNTIFS(L4:AO4, ISDATE(@cell))

 

To count how many of those dates are more recent than 2016:

 

=COUNTIFS(L4:AO4, IFERROR(YEAR(@cell), 0) > 2016)