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.

Find more posts tagged with

Accepted answers

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")

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.