nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

How to SUM a formula

Brooke Clem

I have a long formula string and I need to find a sum of data within that string.

Just to give perspective, my data set is: =COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:design:design-doing:d blocked") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:design:design-doing:design doing") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:sme review:sme review") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:prod-doing:p blocked") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:prod-doing:prod-doing") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:publishing/printing:publishing/printing blocked") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:stitching-ready:stitch blocked") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:translation:spn") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:publishing/printing:publishing:stitching-doing") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:design:design-ready:dr blocked") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:design:design-ready:design ready") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:SME Review:SME Blocked") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:translation:Can") + COUNTIF(LaneTitle:LaneTitle, "food network:deliverables in progress:production:translation:translation blocked")

I need to take this data and figure out: =SUMIFS([Card_Size]:[Card_Size]

How can I do this? Or do I need to SUMIF for every COUNTIF data set?

I've tried several scenarios, but I'm getting 'incorrect argument' and 'unparseable'

Help please?!

タグが付けられた投稿をさらに検索

Accepted answers

Mark Cronk

Good evening, I failed to include the @cell with each criteria. Try these:

=COUNTIF(LaneTitle:LaneTitle, OR( @cell="food network:deliverables in progress:design:design-doing:d blocked", @cell="food network:deliverables in progress:design:design-doing:design doing", @cell= "food network:deliverables in progress:production:sme review:sme", @cell="food network:deliverables in progress:production:prod-doing:p blocked", @cell= "food network:deliverables in progress:production:prod-doing:prod-doing", @cell= "food network:deliverables in progress:publishing/printing:publishing/printing blocked", @cell= "food network:deliverables in progress:production:stitching-ready:stitch blocked", @cell= "food network:deliverables in progress:production:translation:spn", @cell="food network:deliverables in progress:publishing/printing:publishing:stitching-doing", @cell="food network:deliverables in progress:design:design-ready:dr blocked", @cell= "food network:deliverables in progress:design:design-ready:design ready", @cell= "food network:deliverables in progress:production:SME Review:SME Blocked", @cell= "food network:deliverables in progress:production:translation:Can", @cell="food network:deliverables in progress:production:translation:translation blocked"))

=SUMIFS([Card_Size]:[Card_Size], LaneTitle:LaneTitle, OR( @cell="food network:deliverables in progress:design:design-doing:d blocked", @cell="food network:deliverables in progress:design:design-doing:design doing", @cell= "food network:deliverables in progress:production:sme review:sme", @cell="food network:deliverables in progress:production:prod-doing:p blocked", @cell= "food network:deliverables in progress:production:prod-doing:prod-doing", @cell= "food network:deliverables in progress:publishing/printing:publishing/printing blocked", @cell= "food network:deliverables in progress:production:stitching-ready:stitch blocked", @cell= "food network:deliverables in progress:production:translation:spn", @cell="food network:deliverables in progress:publishing/printing:publishing:stitching-doing", @cell="food network:deliverables in progress:design:design-ready:dr blocked", @cell= "food network:deliverables in progress:design:design-ready:design ready", @cell= "food network:deliverables in progress:production:SME Review:SME Blocked", @cell= "food network:deliverables in progress:production:translation:Can", @cell="food network:deliverables in progress:production:translation:translation blocked"))

Mark

All comments

Mark Cronk

Hi @Brooke Clem ,

Convert your formula to:

=COUNTIF(LaneTitle:LaneTitle, OR( "food network:deliverables in progress:design:design-doing:d blocked", "food network:deliverables in progress:design:design-doing:design doing", "food network:deliverables in progress:production:sme review:sme, "food network:deliverables in progress:production:prod-doing:p blocked", "food network:deliverables in progress:production:prod-doing:prod-doing", "food network:deliverables in progress:publishing/printing:publishing/printing blocked", "food network:deliverables in progress:production:stitching-ready:stitch blocked", "food network:deliverables in progress:production:translation:spn", "food network:deliverables in progress:publishing/printing:publishing:stitching-doing", "food network:deliverables in progress:design:design-ready:dr blocked", "food network:deliverables in progress:design:design-ready:design ready", "food network:deliverables in progress:production:SME Review:SME Blocked", "food network:deliverables in progress:production:translation:Can", "food network:deliverables in progress:production:translation:translation blocked"))

=SUMIFS([Card_Size]:[Card_Size], LaneTitle:LaneTitle, OR( "food network:deliverables in progress:design:design-doing:d blocked", "food network:deliverables in progress:design:design-doing:design doing", "food network:deliverables in progress:production:sme review:sme, "food network:deliverables in progress:production:prod-doing:p blocked", "food network:deliverables in progress:production:prod-doing:prod-doing", "food network:deliverables in progress:publishing/printing:publishing/printing blocked", "food network:deliverables in progress:production:stitching-ready:stitch blocked", "food network:deliverables in progress:production:translation:spn", "food network:deliverables in progress:publishing/printing:publishing:stitching-doing", "food network:deliverables in progress:design:design-ready:dr blocked", "food network:deliverables in progress:design:design-ready:design ready", "food network:deliverables in progress:production:SME Review:SME Blocked", "food network:deliverables in progress:production:translation:Can", "food network:deliverables in progress:production:translation:translation blocked"))

Work?

Mark

Brooke Clem

Not yet. I'm getting an #unparseable. But, I might need to just twiddle with it a bit more. I'll try a few things.

Mark Cronk

Good evening, I failed to include the @cell with each criteria. Try these:

Mark

Brooke Clem

This is it! Thank you so much! I've never used the @cell before. very interesting. I appreciate your help!

Mark Cronk

Hi @Brooke Clem ,

Happy to help. Thank you for contributing to the Community.

Mark

Sign in to join the conversation!

クイックリンク

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.