Indirect Function Tutorial - Column Sum, Average & Dependent Drop Down Lists - Excel

[@cat9104]

I don't know if you're aware of the ASMR community.. but my teacher played one of your videos in her class and you and you gave me so much ASMR it nearly put me to sleep (which in the case of ASMR, is good.) You have such a soothing and flowing voice it makes me want to take a nap! You've also been helping me study for my finals next week, thanks for everything!

[@madinaroshan8173]

You’re so smart you literally know everything

[@erikb3799]

Another use for indirect is to name sheets with data and use them as lookup tables. It's a bit like the idea of the named ranges, but it simplifies the naming since once the sheet is named, it's done. I have a daily tracking sheet and then I have a monthly sheet that uses an iferror(indirect()) function to pull the data specified by a column of dates. Each day I make a new sheet for that day and the formulas are already there on the master sheet to pull the data.

[@lucysam5820]

The Organic Chemistry Tutor, How are you? Happy New Year. I found this video and was extremely excited to learn the format that you shared. I do have a query if during the month and or week, I transfer money from checking to savings and or received refunds from purchases, can you share how the formula can be modified to do so? I really appreciate and look forward to seeing that video. Sincerely New Viewer

[@ckaisermomx3]

I have a drop down list with a certain number of shirt sizes and I would like to reduce my size selection when all of them have been selected...for example I have 4 medium jackets and with each medium selection I would like it to reduce the number available and then does not allow medium to be selected at all once all 4 are chosen. Would you have a tutorial that could help me with that?