Hi, I am working on a workflow, and I would like to be able to do a sumif formula. I have read to use a summarize tool but it does not seem to be working for what I need to do. What I am trying to do is predict the amount of $ that we will be retiring in future years. Example : Minor Category Useful Life Rule FY23 FY24 FY25 COMP HARDWARE 3 YRS 3 3 2016 2017 2018 COMP HARDWARE 5 YRS 5 2 2015 2016 2017 Data: Minor Category Year Placed in Service Total COMP HARDWARE 3 YRS 2016 1,549,419.48 COMP HARDWARE 3 YRS 2017 2,263,136.31 COMP HARDWARE 3 YRS 2018 1,115,817.05 COMP HARDWARE 3 YRS 2019 2,367,232.60 COMP HARDWARE 3 YRS 2020 804,957.08 COMP HARDWARE 3 YRS 2021 118,137.88 COMP HARDWARE 5 YRS 2015 431,429.37 COMP HARDWARE 5 YRS 2017 113,130.01 COMP HARDWARE 5 YRS 2018 503,108.79 COMP HARDWARE 5 YRS 2019 330,292.21 COMP HARDWARE 5 YRS 2020 327,019.30 COMP HARDWARE 5 YRS 2021 320,178.22 What I am looking for my output to be: Minor Category FY23 FY24 FY25 Comp 3 Year 1,549,419 2,263,136 1,115,817 Comp 5 Year 431,429 - 113,130 Each minor category has different years so I am trying to do a sumif to pull in the total amount based off of the rule that is associated with the category by year. Any guidance on this would be greatly appreciated! Thank you! Kim
