SUMIFS

Del Horne

Hi,

I'm looking to sum the cells in a column if another corresponding column is either of two values. I'm getting #UNPARSEABLE though! 😕

=SUMIFS({Data Range Spend}, {Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”))

Any thoughts welcome!

Thanks,

Derek

Paul Newcome

Looks like you have smart quotes from a program similar to Microsoft Word.

Try retyping directly in Smartsheet, and you will see that the quotes are straight up and down instead of slanted. This should take care of it for you.

Paul Newcome

Looks like you have smart quotes from a program similar to Microsoft Word.

Try retyping directly in Smartsheet, and you will see that the quotes are straight up and down instead of slanted. This should take care of it for you.

Del Horne

@Paul Newcome you are a saviour!

I pasted the formula into TextEdit to size up to look at the issue...not thinking to convert to plain text. Arrrrrgh. Thank you!!

Paul Newcome

Happy to help. 👍️

I usually use Notepad for that as it also uses plain text.