Sum of a column based on multiple factors

I want to take the Sum of Column A from another sheet if column B shows "Loan Declined" and Column C shows either "Underserved" or "Low-Income".

I tried the following formula to achieve this but none of them are reporting the needed information:

=SUMIFS({Column A}, {Column C}, "Underserved", {Column C}, "Low-Income", {Column B}, "Loan Declined")

Is there another formula that can help me obtain the answer that I want to generate?

I appreciate the assistance!

Find more posts tagged with

Accepted answers

STA13

I am not sure if I am applying it correctly.

I applied this formula:

=SUMIFS({Denied Loans Obligated Loan Amount}, {Denied Loans underserved low income}, OR({Denied Loans underserved low income} = "Underserved", {Denied Loans underserved low income} = "Low-Income"), {Denied Loans Review Status}, "Loan Declined")

It states Invalid Operation

My issue is the column C is a drop-down menu and want to incorporate 2 of the 3 possibilities within this formula. My goal is to capture each applicable row and add the total loan amounts together. I am wondering if I cannot use a drop-down menu to execute this correctly since I want 2 of the 3 options… or maybe I need to separate it further to provide the totals for each separate answer and then I can create a function to provide the full sum.

All comments

Paul Newcome

Try this:

=SUMIFS({Column A}, {Column C}, OR(@cell = "Underserved", @cell = "Low-Income"), {Column B}, "Loan Declined")

STA13

I am not sure if I am applying it correctly.

I applied this formula:

It states Invalid Operation

STA13

@Paul Newcome I realized that I did not tag you in my last response. Thank you for responding talking through the problem helped me find a solution even if it was having to break it down in order to obtain the same result.

I appreciate your help!

Paul Newcome

Try leaving the @cell references exactly how they are in my post.

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.