This is the lesson that convinced me to buy the premium course. Loving it so far
Thanks! Glad to hear it. We are adding to it and revising content each quarter this year.
Thank you for awesome content!
Just AMAZING ! I wish I had seen this video 1 year when I did all this work manually
Thanks! Glad to hear it.
Great video, very easy to follow. Thank you!
Thanks for watching!
Thnx for these vids. Really appreciate them! Keep it up!:)
This was excellent. Thank you.
Your content never disappoints!
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! :-)
Impressive! Thank you so much
Terrific!
Hi, where can I download the excel file used in the video?
Click "Show More". Click the links under "Resources."
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
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,"
very very scary
Or you could just pivot table the quarters data and filter it by year
You could, but they asked for a formula solution, not something using pivot tables.
This is a nice and clear guide, but using the sumproduct function as a “2 directional sumif” would be much easier than this
Yes, that's true, but the goal here was to illustrate how INDIRECT works in this context.
Could you provide the solution with sumproduct ? Thansk a lot
This is the lesson that convinced me to buy the premium course. Loving it so far
Thanks! Glad to hear it. We are adding to it and revising content each quarter this year.
Thank you for awesome content!
Just AMAZING ! I wish I had seen this video 1 year when I did all this work manually
Thanks! Glad to hear it.
Great video, very easy to follow. Thank you!
Thanks for watching!
Thnx for these vids. Really appreciate them! Keep it up!:)
Thanks for watching!
This was excellent. Thank you.
Thanks for watching!
Your content never disappoints!
Thanks for watching!
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! :-)
Thanks for watching!
Impressive! Thank you so much
Thanks for watching!
Terrific!
Thanks for watching!
Hi, where can I download the excel file used in the video?
Click "Show More". Click the links under "Resources."
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
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,"
very very scary
Or you could just pivot table the quarters data and filter it by year
You could, but they asked for a formula solution, not something using pivot tables.
This is a nice and clear guide, but using the sumproduct function as a “2 directional sumif” would be much easier than this
Yes, that's true, but the goal here was to illustrate how INDIRECT works in this context.
Could you provide the solution with sumproduct ?
Thansk a lot