Forum Discussion
juan jimenez
Apr 29, 2021Iron Contributor
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 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
You could do it like this:
The formula in I6 is =SUMIFS(E:E,D:D,">="&H3,D:D,"<="&I3)
ā
4 Replies
You could do it like this:
The formula in I6 is =SUMIFS(E:E,D:D,">="&H3,D:D,"<="&I3)
ā
- juan jimenezIron ContributorHans, 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