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 < t ...more