Reference Another Sheet

Hi all,

I am very sorry that I have to call for your assistance but finding the answer is not really straightforward.

I have a formula that works, yahoo! but it works if I keep it on the same sheet.

Now I want to use this formula that use all the data form another Reference Another Sheet (RAS).

Do I have to add the RAS for each particular criteria, range, … or can I use the RAS only once at the beginning of the formula;

=SUMIF(Date:Date, YEAR(@cell ) = 2025, [EcoFun Food]:[EcoFun Food])

How to use this with RAS?

=SUMIF({Recycling Data Collection Home Range, Date:Date, YEAR(@cell ) = 2025, [EcoFun Food]:[EcoFun Food]))

I know this doesn't work so please help me out with this thanks.

Marc

Find more posts tagged with

sheet reference

Accepted answers

marcBelg67

thanks for the answer but it doesn't solve my query 100%.

So, I did a bit of tweaking and this the correct formula that works;

=SUMIF({Recycling Data Collection Home Range 1}, YEAR(@cell) = 2025, {Recycling Data Collection Home Range 2})

Thanks for your help it did made me investigate further.

Marc

All comments

kowal

hi @marcBelg67 ,

I can see there is syntax error in your second formula… I if you are building the range it shall be like:

=SUMIF({Recycling Data Collection Home Range}, 2025)

so the {Recycling….} is the range of your Date:Date column in another sheet and 2025 is just the criteria….

marcBelg67

thanks for the answer but it doesn't solve my query 100%.

So, I did a bit of tweaking and this the correct formula that works;

=SUMIF({Recycling Data Collection Home Range 1}, YEAR(@cell) = 2025, {Recycling Data Collection Home Range 2})

Thanks for your help it did made me investigate further.

Marc

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.