Forum Thread:

Using Sumifs, Add a Filter for <Today()-365

I have a MS Query capturing inventory values and need to target the slowest moving inventory parts into segments based on their set-up dates. So if I have , =SUMIFS(M:M,E:E,"<=0",H:H,">0",J:J,"<=0",K:K,"<=0") and want to add the date filter (exclude records with setup date < today -365, How-to?

Be the First to Respond

Share Your Thoughts

  • Hot
  • Active