SUMIF with multiple columns

This should be simple but I appear to be going wrong somewhere.

I have the following working for two columns

=SUMIF([Loan Manager]:[Loan Manager], "GE", [Loan Amount]:[Loan Amount])

When I try to add another look up column it doesn't work, as below

=SUMIF([Loan Manager]:[Loan Manager], "GE" , [Loan Status]:[Loan Status], "Green", [Loan Amount]:[Loan Amount])

I've also tried with SUMIFS.

Any help will be greatly appreciated.

Find more posts tagged with

Hi,

Try something like this.

=SUMIFS([Loan Amount]:[Loan Amount]; [Loan Manager]:[Loan Manager]; "GE"; [Loan Status]:[Loan Status]; "Green")

The same version but with the below changes for your and others convenience.

=SUMIFS([Loan Amount]:[Loan Amount], [Loan Manager]:[Loan Manager], "GE", [Loan Status]:[Loan Status], "Green")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

That is probably because of the difference in syntax between SUMIF and SUMIFS.

SUMIF(criteria range, criteria, sum range)

SUMIFS(sum range, criteria range 1, criteria 1, criteria range 2, criteria 2, ...................)

Note that in the SUMIF, the sum range is entered last and is optional. In SUMIFS, the sum range is required, and it is entered FIRST.

Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…