Trying to Figure Out a SUMIFS Formula

I am trying to create a formula that add the 'total pieces of media' if the 'type of media' is 'still' and the 'current / upcoming' is empty. The formula I am using is below and I keep getting invalid operation.

Not sure what I am doing wrong. Thank you for any help I can get. :)

=SUMIFS([Total Pieces of Media]:[Total Pieces of Media], [Type of Media]:[Type of Media] = "Still", [Current / Upcoming (USC/NARA)]:[Current / Upcoming (USC/NARA)], ISBLANK(@cell))

Best Answer

  • SmartLew
    SmartLew ✭✭✭✭
    Answer ✓

    you don't need the equals sign after your type of media range, you need a comma to distinguish the criterion range from the criteria

    it should look like this

    =SUMIFS([Total Pieces of Media]:[Total Pieces of Media], [Type of Media]:[Type of Media] ,"Still", [Current / Upcoming (USC/NARA)]:[Current / Upcoming (USC/NARA)], ISBLANK(@cell))

    I'm passionate about helping you leverage the truly awesome power of smartsheet!

    https://www.fiverr.com/smartlew

Answers

  • SmartLew
    SmartLew ✭✭✭✭
    Answer ✓

    you don't need the equals sign after your type of media range, you need a comma to distinguish the criterion range from the criteria

    it should look like this

    =SUMIFS([Total Pieces of Media]:[Total Pieces of Media], [Type of Media]:[Type of Media] ,"Still", [Current / Upcoming (USC/NARA)]:[Current / Upcoming (USC/NARA)], ISBLANK(@cell))

    I'm passionate about helping you leverage the truly awesome power of smartsheet!

    https://www.fiverr.com/smartlew

  • Thank you so much! It is always the little tweak! Thank you thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!