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

Find more posts tagged with

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.