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: OfficeTutes.com

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