Forum Discussion

akosmolnar1's avatar
akosmolnar1
Copper Contributor
Nov 22, 2023

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...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Nov 22, 2023

akosmolnar1 

In F6:

 

=SUMIFS(C:C, A:A. E6, B:B, ">="&EDATE(MAXIFS(B:B, A:A. F6), -12))

 

Fill down.

  • akosmolnar1's avatar
    akosmolnar1
    Copper Contributor
    Nov 23, 2023
    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?
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 23, 2023

      akosmolnar1 

      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))

      • akosmolnar1's avatar
        akosmolnar1
        Copper Contributor
        Feb 01, 2024

        Thank you HansVogelaar for your help! 

        I truly appreciate it!