Trying to Figure Out a SUMIFS Formula

Options

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))

• ✭✭✭✭
Options

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

• ✭✭✭✭
Options

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

• Options

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!