Apr 29 2021 11:39 AM
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
Apr 29 2021 11:44 AM
SolutionApr 30 2021 02:44 AM
Apr 30 2021 02:54 AM
See the attached version.
Apr 30 2021 07:35 AM
Understood. thant you very much!
Apr 29 2021 11:44 AM
SolutionYou could do it like this:
The formula in I6 is =SUMIFS(E:E,D:D,">="&H3,D:D,"<="&I3)