Microsoft Excel 2013 - Combining the SUMIFS and INDIRECT functions

This video demonstrates using Microsoft Excel’s SUMIFS function to total up a range of cells across multiple worksheets based multiple criteria ranges / criteria and adds a further level of complexity by nesting Excel’s INDIRECT function and concatenation.
This video was created by Optimum - the IT Training Consultancy.
For more information on our Microsoft Office training courses provided in central London, UK - please click here: www.optimum.co.uk/microsoft-of...

[@michaelburch3693]

Wonderful explanation! There are a lot of videos out there attempting to explain this concept and you by far have done the best! Top notch!

[@marcwert9552]

I can't begin to tell you how much time you just saved. Thanks so much for the clear step by step example.

[@stefbo4901]

Thanks a lot ! Clear explanation comparing to other videos. More easy to understand this step by step approach !

[@ubaidillahmuhammad20]

nice job. put link excel file in the description video ,,,,,

[@hanskdavis]

i've got a lot to learn... geez.