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)
Format doesn't matter. To sum within month you may use
=SUMIFS(Sheet2!$D:$D,Sheet2!$C:$C,">" & EOMONTH(B$1,-1),Sheet2!$C:$C,"<=" & EOMONTH(B$1,0),Sheet2!$B:$B,$A2)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!
- Hi,
Try below formula:
=SUMPRODUCT((YEAR(Sheet2!$B$2:$B$100000)=YEAR($A2))*(MONTH(Sheet2!$B$2:$B$100000)=MONTH($A2))*(Sheet2!$C$2:$C$100000=B$1)*(Sheet2!$D$2:$D$100000))
Hope this helps.
Regards,
IlirU- Thank you! this works!
