Formula to count fields that are not blank

Cynthia823
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! :)

Comments

  • Paul Newcome
    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)

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!