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

Mary Hum

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.

Paul Newcome

The syntax (assuming cross sheet references are properly created) would look something like this...

=SUMIFS({Reference Sheet Amount Column}, {Reference Sheet Category Column}, "Shoes")

Paul Newcome

The syntax (assuming cross sheet references are properly created) would look something like this...

=SUMIFS({Reference Sheet Amount Column}, {Reference Sheet Category Column}, "Shoes")

Mary Hum

Thanks for your help Paul!

Paul Newcome

Happy to help! 👍️