SUMIFS with two criteria

Deborah Kardash

2020 Invoice Status.xlsx

2020 Monthly Invoice Visibility.xlsx

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.

Paul Newcome

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.

Paul Newcome

Let's try a little rearrangement on your first formula...

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

Deborah Kardash

Hi Paul,

Thanks for responding. I am getting #UNPARSEABLE. If you have any other ideas, I am open.

This is driving me crazy.

Have a nice evening.

Deb

Paul Newcome

Can you copy/paste the exact formula from your sheet?

Deborah Kardash

Invoice Visibility File Formula

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

Thanks Paul I appreciate your time.

Paul Newcome

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.

Deborah Kardash

Hi Paul,

No apologies, I appreciate the help. It worked. You just made my day.

Thanks for all the help.

Have a nice day.

Deb

Paul Newcome

Excellent! Happy to help! 👍️