Forum Discussion
Need help with excel formula
Hi there,
I would need some help creating a formula. I would prefer a 'simple' Excel formula, not VBA.
I want to summarize the values that belong to the same item, but not every value. For each line there is a date when the value was created, I want to add only those values that fall between the last 12 months counting from the most recent date for each item which varies for each item.
So in my example:
Item 'C' has 8 lines, I want to add only those lines that fall between Dec 5, 2020 (the most recent date), and Dec 5, 2019 (Dec 5. 2020 -12 months).
Could anyone help me figure out a formula that could work?
Thank you,
4 Replies
- Thank you so much! In google sheets it works great!
In my company, we use office 2016 where maxifs was not introduced yet. Do you perhaps have a workaround for this?As an array formula confirmed by pressing Ctrl+Shift+Enter:
=SUMIFS(C:C, A:A. E6, B:B, ">="&EDATE(MAX(IF(A:A=F6, B:B)), -12))
