Header Ads



Download This Video Mp4/Mp3

Download This Video Mp4/Mp3

Download This Video Mp4/Mp3


Ads by Eonads



Download Excel Start File: https://ift.tt/3oEL9KD

Download Excel File: https://ift.tt/MQAomx
See a formula that will calculate the total insurance allocation for five employees based on whether or not the previous three months had paychecks. Learn how to use the MMULT function and matrix multiplication to add numbers from a row in a two-way array and return a column of answers that the SUMPRODUCT function can then use for calculations of an insurance allocation.

Great Array Formula trick from chapter 18 in the book that will be published in July 2013; Ctrl + Shift + Enter, Mastering Excel Array Formulas.




Excel 2013,Excel 2003,Excel 2007,Excel 2010,excelisfun,Mike Girvin,Highline Community College,Slaying Excel Dragons,Ctrl Shift Enter Mastering Excel Array Formulas,Insurance Calculation,five employees,previous three months,MMULT function,SUMPRODUCT function,matrix multiplication,COUNTIF function


Ads by Eonads


No comments