Microsoft Excel 2016 or Excel 365 - Using SUMPRODUCT and a clever mix of Absolute and Relative to calculate a whole table of values from one calculation! This video is from Lesson 10 of the Excel 2016/365 Level 3 course which can be found at: https://www.knowledgemarket.ie/courses/excel-2016-level-3/
Hi, I’m Kelly and you’re very welcome to my channel! All videos shown are in version 2016/365, but I also have these videos in version 2013 and 2010 on my website: https://www.knowledgemarket.ie Enjoy!