Excel Tests in Interviews: INDIRECT, MATCH, SUMIFS, and More

[@Eduardozco]

This is the lesson that convinced me to buy the premium course. Loving it so far

[@financialmodeling]

Thanks! Glad to hear it. We are adding to it and revising content each quarter this year.

[@Bertztuful]

Just AMAZING ! I wish I had seen this video 1 year when I did all this work manually

[@financialmodeling]

Thanks! Glad to hear it.

[@parkervance3700]

Great video, very easy to follow. Thank you!

[@financialmodeling]

Thanks for watching!

[@xhesitase9729]

Your content never disappoints!

[@financialmodeling]

Thanks for watching!

[@serhiidubrovin8205]

Thank you for awesome content!

[@davidcarragher5151]

This was excellent. Thank you.

[@financialmodeling]

Thanks for watching!

[@Batmanananana]

Thnx for these vids. Really appreciate them! Keep it up!:)

[@financialmodeling]

Thanks for watching!

[@alanmt8819]

It's just awesome! Encountered those puzzling things before, but only in this video it is explained absolutely clearly! Thank you guys for such a great content! :-)

[@financialmodeling]

Thanks for watching!

[@kendrewt]

Terrific!

[@financialmodeling]

Thanks for watching!

[@zelinli4287]

Impressive! Thank you so much

[@financialmodeling]

Thanks for watching!

[@jonaswesley2658]

so why did you anchor the number "2" in the formula? i didn't get that. To me it seems like nothing is achieved by doing so

[@financialmodeling]

There are several references to "2" in this formula, so I don't know which you're referring to, but if it's something like this, Quarters!$E$2:$T$2,"

[@pv0315]

very very scary

[@TheNBFCOAProductions]

This is a nice and clear guide, but using the sumproduct function as a “2 directional sumif” would be much easier than this

[@financialmodeling]

Yes, that's true, but the goal here was to illustrate how INDIRECT works in this context.

[@randomizer_1234]

Could you provide the solution with sumproduct ?
Thansk a lot

[@garimakhanna8625]

Hi, where can I download the excel file used in the video?

[@financialmodeling]

Click "Show More". Click the links under "Resources."

[@bigworm3886]

Or you could just pivot table the quarters data and filter it by year

[@financialmodeling]

You could, but they asked for a formula solution, not something using pivot tables.