excel sum if multiple criteria

[juan jimenez]

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 a range of years.

I wonder if someone could help me with formulas so that i do not have to put ">" or ">" every time i change the years.

Thank you, Juan

[#2 · Accepted solution]

@juan jimenez 

You could do it like this:

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

 

[#3]

Hans, it works!
do you know how i could also make it works on colonne C, where i have the exact date?
Thank you very much, Juan

[#4]

@juan jimenez 

See the attached version.

[#5]

@Hans Vogelaar 

Understood. thant you very much!