Formula needed - adding total of one column dependent on other columns criteria

I need the sum of one column conditional to the criteria of 3 other columns; below is the formula I am attempting to use with the goal of obtaining the sum of [% KRs Contribute to Corp Objs] that have the below additional columns criteria. Can anyone review and let me know if I need a different formula or what I am missing? Thanks!

=(IF([Corporate Objective]:[Corporate Objective], "Foundation for Scale", (Stage:Stage), "Completed", (Level:Level, "Corporate", =SUM([% KRs Contribute to Corp Objs]:[% KRs Contribute to Corp Objs]))

Find more posts tagged with

Formulas

Accepted answers

Andrea Hoerr

Hi Ashley,

Perhaps this will help. I use this to sum up the # of points if certain criteria are met.

=SUMIFS([Points]:[Points], [Target Month]:[Target Month], ="May", Disposition:Disposition, @cell <> "Analyze", Disposition:Disposition, @cell <> "Remain")

All comments

Vivienne Strettle

Hi Ashley. It looks like you need the SUMIFS formula. This allows you to add up values in one column based on multiple criteria. If you type =SUMIFS into a field you'll get help with the syntax and further explanation on how to use it. I you have a problem I'd be happy to help if you don't find what you need. Viv

Ashley Archibeque

Thank you for your response Vivienne - the problem is I want the sum of the column [% KRs Contribute to Corp Objs] IF this criteria qualifies first: =(IF([Corporate Objective]:[Corporate Objective], "Foundation for Scale", (Stage:Stage), "Completed", (Level:Level, "Corporate", = SUM of [% KRs Contribute to Corp Objs] that have this criteria.

I am not sure how a SUMIFS would work here....could you provide the format for the formula and how it should look it possible?

Andrea Hoerr

Hi Ashley,

Perhaps this will help. I use this to sum up the # of points if certain criteria are met.

=SUMIFS([Points]:[Points], [Target Month]:[Target Month], ="May", Disposition:Disposition, @cell <> "Analyze", Disposition:Disposition, @cell <> "Remain")

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.