1 Reply Latest reply on Jun 7, 2018 8:52 AM by Ken Flerlage

    Max Date formula with filter

    Ryan F



      I had created a formula that was working great however after adding a filter to my workbook I lose the ability to use the formula. What I was trying to do was show the sum for the max date.


      currently, the below formula is adding all the values.


      IF [Date (Sheet1)] = { MAX([Date (Sheet1)])} THEN [Instagram Followers (SUM)] END


      [Date (Sheet1)]  is the date filter


      The structure of the data is very simple with just date by day and the number of followers.


      thanks for the help