Highline Excel Class 08: 3-D Cell References Add Across Sheets

[muiseec]

Hi

I have number of Seets and the sheet names is used as column label on a summary table. I am trying to sumif and refer to the column label as criteria to jump to that perticular sheet for range and sum_range.

Is there a way this can be achieved.

Thanks in anticipation.

Regards

[ExcelIsFun]

INDIRECT function can do it, Try this video title:

YTLE#62: VLOOKUP INDIRECT & Lookup in Different Tables

[muiseec]

@ExcelIsFun Thanks a lot, I got it after lots of trial and error.

Thanks once again, really appreciate it!

Regards

RJ

[ExcelIsFun]

You are welcome!

[Iaradorgan]

you are a master in excel man! Thank you very much !

[mihaisprinceana]

At the final of video you did the error intentionally to show us how is good.

Thank you very much for your videos!!

If I encounter questions I'll use mrexcel forum.

[ExcelIsFun]

I am glad that the video helped!

[6642633]

Thanks A Lot this is Very Helpful

[ExcelIsFun]

I am glad that it helped!

[Croz1007]

I have one table with multiple lines of information per section (each row is a value in an equation). On another tab I have the same sections listed, but they each only have one row. This single row needs to refer to the third row in each section on the other tab. Confused?

How can I add in a cell reference on the new tab to refer to each needed row (only the third row in a section) when copying my equations down.

[ExcelIsFun]

If your data is on a sheet called Data in the range A1:A151, use this formula to retrieve every third value as you copy the formula down:

=INDEX(Data!$A$1:$A$151,ROWS(A­$1:A1)*3)

[Croz1007]

Thanks.

Here is what I am trying to do:

**(in row 23) =SUM(C5:H5)/SUM(C4:H4)

**(in row 24) =SUM(C9:H9)/SUM(C8:H8)

etc.

Will the index function work in these equations to refer to the proper cells? If so, how? I guess this is where I get confused. How to refer to the proper cells.

[ExcelIsFun]

You are welcome!

[LadyDboz]

WOW THIS IS AWSOME, THANK YOU SO MUCH

[ExcelIsFun]

Dear LadyDboz,

You are welcome so much!!!

--excelisfun

[chippendails]

Hey,

how do you blow things up in the way you do it?

[ExcelIsFun]

Dear chippendails,

To "Zoom" I use Ctrl + Roller Ball On Mouse!