SUMIF with multiple columns

Sanj
Sanj ✭✭
edited 12/09/19 in Smartsheet Basics

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.

Comments