Forum Discussion
EDATES and SUMIFS Help
Hi All, I have created a spreadsheet showing all frequent costs of my company which has columns for frequency, date and description. On my second sheet I have the dates for 6 months across the top...
kayleigh1975 Perhaps something along these lines might help:
=SUMIF(AA$2:BE$2,IF(BF$2=EOMONTH(BF$2,0),EOMONTH(BF$2,-1),EDATE(BF$2,-1)),AA12:BE12)
However, it's not very clear what should happen if there is a cost on both Aug 30th and Aug 31st. Should Sep 30th ignore Aug 30th? Or how about if there's a cost entered on Aug 30th but not on Aug 31st?