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 lin...
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?
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))
Thank you HansVogelaar for your help!
I truly appreciate it!