Forum Discussion

juan jimenez's avatar
juan jimenez
Iron Contributor
Apr 29, 2021
Solved

excel sum if multiple criteria

Hi,   I am trying to add numbers different years. I would like to have the possibility to do it through the column of dates or the column of years. Sometimes I need to know just 1 year, others...
  • HansVogelaar's avatar
    Apr 29, 2021

    juan jimenez 

    You could do it like this:

    The formula in I6 is   =SUMIFS(E:E,D:D,">="&H3,D:D,"<="&I3)

Resources