Forum Discussion
Solved
Excel - match dates in dfferent formats
Hello, In the excel attached I am trying to sum all the dates in the second tab into a different format on the first tab. i.e Sum of all dates in January 2018. Even when I format the dates in...
Sorry for the misprint. Corrected formula is
=SUMIFS(Sheet2!$D:$D, Sheet2!$B:$B,">" & EOMONTH($A26,-1), Sheet2!$B:$B,"<=" & EOMONTH($A26,0), Sheet2!$C:$C,E$1)
Sorry please see attached. The highlighted cell should bring back 423. The school term is not a date. I am trying to match column B on sheet 2, with column A on sheet 1
Thank you!
Sorry for the misprint. Corrected formula is
=SUMIFS(Sheet2!$D:$D, Sheet2!$B:$B,">" & EOMONTH($A26,-1), Sheet2!$B:$B,"<=" & EOMONTH($A26,0), Sheet2!$C:$C,E$1)- Thank you! This is so useful for me and all my other spreadsheets!
JennyHoA20181 , you are welcome, glad it helped
- Hello!
On the same subject how do I get the formula below:
=SUMIFS(Sheet2!$D:$D, Sheet2!$B:$B,">" & EOMONTH($A26,-1), Sheet2!$B:$B,"<=" & EOMONTH($A26,0), Sheet2!$C:$C,E$1)
To reflect <= Dec 19 rather the formula above which would bring back number of records just for month of Dec 19.
Thank you!