SUMIFS with ISBLANK, something is wrong

=SUMIFS(Amount:Amount, Unit:Unit, "Facilities Devel & Mgmt", ISBLANK(COVIDSpendingCategory:COVIDSpendingCategory), "Cell isn't blank"])


  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭

    Taking a stab in the dark here, as I'm not sure of the context...

    If the ISBLANK is referring to one cell, I'd suggest ISBLANK(COVIDSpendingCategory).

    If looking across a range of cells, maybe try IF(COVIDSpendingCategory:COVIDSpendingCategory <>"", "Cell isn't blank" etc.

    The way I understand it

    using <>"" is like saying 'is not blank'

    Similarly =" " is like saying 'is blank'

    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!