Trying to Figure Out a SUMIFS Formula

Olivia Doiron

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

SmartLew

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

SmartLew

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

Olivia Doiron

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