What is the syntax to reference another sheet when using formulas?

I want to use add up costs in an AMOUNT column when the value in the CATEGORY column is SHOES and this display this in a Summary Order sheet.  Can someone tell me what is wrong with the syntax of this formula:

=SUMIFS({REFERENCE SHEET}, AMOUNT:AMOUNT, CATEGORY:CATEGORY, "Shoes")

I've already tried the Learning Center notes, but the information there isn't clear enough about syntax.

Thanks.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!