SUMIFS with two criteria


I am trying to SUM up the invoices were the Status is Match by Month and report on another file. I am having trouble with the formula.

=SUMIFS({InvoicebyMonth}, [Invoice Visibility]3, {InvoiceAmt}, {MatchedStatus},"Matched”)

To get the count of invoices I ended up putting in a column to show the number of invoices processed so I could enter a 0 if in Error and the formula below worked.

=SUMIF({InvoicebyMonth}, [Invoice Visibility]1, {Processing}

The intent is for the Monthly Invoice Visibility to be available in a Dashboard but in Real time once the formula is working.

Any help would be appreciated as I am still learning but trying to build a complex dashboard.

Thanks in advance for your help.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Found it. You have a set of "smart quotes". Notice in your pasted formula how the last set of quotes is obviously "closing" because of how they are shaped/slanted as opposed to straight up and down like the first quotes and all of the quotes in this comment?

    This happens when you type quotes into programs such as Microsoft Word. If you use a program such as Notepad or you type directly into Smartsheet (or here in the Community), you will not get the "smart quotes".

    Go into your sheet, delete the last quote, then retype it. See if that works for you. My apologies for not catching that sooner. When I rearranged your original formula, I was just copy/pasting from your post and didn't notice them because I was focused on the syntax.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!