SUMIFS in Datameer


1 comment

  • Grant Eaton

    Hi Jesu,

    If I understand your question correctly, I think you should be able to create a "Prep" worksheet with two columns. One column in that worksheet will contain a conditional formula that indicates the Sale Price IF the Purchase Year = 2016 otherwise 0; and the other column will do the same but where the Purchase Year = 2015. Note that the constants of 2016 and 2015 could be exchanged for dynamically formatted year variables derived by using the TODAY function coupled with YEAR.

    In the simplest method, your first column would look something like this:


    Your second column would look like:


    Then, you would GroupBy() CustomerName in your results worksheet and GroupSum the two conditional columns from your Prep worksheet. You can then make it more sophisticated by making the date test dynamic instead of static.

    Did I understand your question correctly?


    Comment actions Permalink

Please sign in to leave a comment.