SUMIFS with ISBLANK, something is wrong

Amber Perez
Amber Perez ✭✭
in Formulas and Functions

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

· Share on FacebookShare on Twitter

Answers

  • 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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!