Hi all! I set up a formula similar to this: =SUMIFS($A:$A,$B:$B,">="&D1,$B:$B,"<="&EOMONTH(D1,0)) to calculate projected costs for current/future months.
However, in the main set of data there HAS to be a problem because it will not calculate the last day of the month for any month.
Any idea what could be wrong? I didn't set up the spreadsheet where the data is pulled from so I don't know where to look!
Thank you
However, in the main set of data there HAS to be a problem because it will not calculate the last day of the month for any month.
Any idea what could be wrong? I didn't set up the spreadsheet where the data is pulled from so I don't know where to look!
Thank you
