Help w/ Sumif date is before today



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?

Best Answer

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Answer ✓

    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 - Sevan Technology

    Smartsheet Aligned Partner


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!