Microsoft Excel 2013 – Combining the SUMIFS and INDIRECT functions

About this tutorial:

Video duration: 00:11:19
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:

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads