Help w/ Sumif date is before today

Alex Hackford

Hi,

Hitting a snag w/ a very basic sumif. I need to sum the total capital investment column if it's corresponding date value falls before or on today's date. Here's the formula I have now:

=SUMIF([Fiscal Month End]1:[Fiscal Month End]12, <=TODAY(), [Actual Capital Investment]1:[Actual Capital Investment]12)

And a screenshot:

The formula is currently returning $0 and but should be summing the Actual capital investment to $1,606,566.5. I've tried flipping the >= but am getting $0 both ways. Any pointers?

Jason Tarpinian

Your formula looks good! But is your "Fiscal Month End" formatted as a date column? It looks like a text (should have the leading 0's for the months). Double click on the header to change it to a Date type column and you should be good to go!

Jason Tarpinian

Your formula looks good! But is your "Fiscal Month End" formatted as a date column? It looks like a text (should have the leading 0's for the months). Double click on the header to change it to a Date type column and you should be good to go!

Alex Hackford

Wow, thank you! Always forget to check the date formatting!