I need help summing up the value of one column based on the status of another

I have two sheets I am using— one with all my data, reference points, and another with all my formulas.

I want to sum up all the numbers in my 'Annual Revenue' column based on the Status column (completed, in progress, etc) of that same row.

I want to use this formula in my other sheet which holds all formulas and data. i am using the below formula but keep getting UNPARSABLE:

=SUMIF({Total Revenue}:{Total Revenue}, {StatusRange 1}:{StatusRange 1}, "Completed")

Please help! I've given myself a headache trying to figure this out.

Thank you in advance!

Find more posts tagged with

Accepted answers

Mark.poole

you were almost there. When you create a column reference as a cross sheet reference you don’t need the : functionality. Instead this should work.

=SUMIFs({Total Revenue}, {StatusRange 1}, "Completed")

All comments

Mark.poole

you were almost there. When you create a column reference as a cross sheet reference you don’t need the : functionality. Instead this should work.

=SUMIFs({Total Revenue}, {StatusRange 1}, "Completed")

claudia.alay

Thanks Mark! 1 set step closer at least I am no longer getting UNPARSABLE, but now I got INCORRECT ARGUMENT SET.

any tips?

Mark.poole

I edited my comment. It’s sumifs not sumif

claudia.alay

That did the trick! Thanks so much Mark!

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