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.
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 450 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives