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

Ashley Archibeque

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

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

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