SUMIF with multiple columns

Sanj

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.

Andrée Starå

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

Paul Newcome

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.