Reference Another Sheet

marcBelg67

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

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

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