Multiple If Statements

@ChrisMcKay ✭✭✭
edited 12/09/19 in Formulas and Functions

I'm having a difficult time making multiple 'If' statements work, cross sheets. I would like the sum of a column to be brought over to another sheet IF it meets the following criteria:

1. meets a corresponding category, and,

2. has a check box.

The first half works (below), without the check box being checked:

SUMIF({LGES - Invoices Range 1}, Item9, {LGES - Invoices Range 2})

Now, adding the check box:

=IF({LGES - Invoices Range 3} = "1", SUMIF({LGES - Invoices Range 1}, Item9, {LGES - Invoices Range 2}), false)

Am I not creating the If argument correctly for the checkbox?


Screen Shot 2018-06-22 at 5.10.06 PM.png

Screen Shot 2018-06-22 at 5.09.51 PM.png



  • Kelsey Hayden


    Thanks for reaching out! If you’re looking to sum a range based on multiple specified criteria then you will want to consider using the SUMIFS function.

    Utilizing this function will allow you to sum the Amount, so long as the Approved column is checked and the Category column contains "Legal Fees". Based on the data you provided, you can insert a formula similar to the one below into the Paid to Date column of your second sheet:

    =SUMIFS({LGES - Invoices Range 2}, {LGES - Invoices Range 3}, 1, {LGES - Invoices Range 1}, Item9)

    More information on the SUMIFS function can be found in this Help Center article:

    Please let me know if you’re looking for something else and I’ll be more than happy to advise further!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!