Stuck with SumIF

Hi. Fairly new to smartsheets. I need to sum up by Month and customer name. I am getting an error message with the formula below.

=SUMIF([Invoice Month]:[Invoice Month], "4 - APR", [Customer Name]:[Customer Name], "Amazon", [Invoice Total]:[Invoice Total])

Can someone help me fix the error?


Thanks!

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Jackie Ortiz

    It looks like you're just missing the S from SUMIFS to make it plural (aka looking at multiple columns).

    With a plural SUMIFS you'll want to have the Sum Range column be listed first, too.

    Try this:

    =SUMIFS([Invoice Total]:[Invoice Total], [Invoice Month]:[Invoice Month], "4 - APR", [Customer Name]:[Customer Name], "Amazon")

    Cheers!

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!