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...
- Apr 29, 2021
You could do it like this:
The formula in I6 is =SUMIFS(E:E,D:D,">="&H3,D:D,"<="&I3)
ā
juan jimenez
Apr 30, 2021Iron Contributor
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
do you know how i could also make it works on colonne C, where i have the exact date?
Thank you very much, Juan
HansVogelaar
Apr 30, 2021MVP
See the attached version.
- juan jimenezApr 30, 2021Iron Contributor
Understood. thant you very much!