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

    Max Date formula with filter

    Ryan F

      Hi,

       

      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