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?!

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

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:

=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

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