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

  • Andrée Starå
    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

    work-bold

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Paul Newcome
    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.