Excel Magic Trick 1022: Sample Chapters of Ctrl + Shift + Enter Book & SUMPRODUCT example

3,783 views · Published 22 July 2013 · 2:52 · Indexed 6 November 2026

Channel: excelisfun · 2013 · Education

Watch on YouTube

Download Excel Start File:  https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1022.xlsx

Download sample chapters of Ctrl + Shift + Enter: Mastering Excel Array Formulas:
Chapter 19:
http://issuu.com/mrexcel/docs/ctrlshiftentersamplechapter 
Chapter 2:
http://issuu.com/mrexcel/docs/ctrlshiftentersamplechapter_f91b85843acf75 
Download workbook example from video: http://people.highline.edu/mgirvin/excelisfun.htm

Example of a basic SUMPRODUCT function formula for multiplying two arrays. Take the bill range and quantity range and multiply them to get the total bank deposit.

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,560 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,596 views · 30 May 2008

• 3:41 YouTubersLoveExcel#26.2: Formulas do not like TEXT Time

  excelisfun

  2,016 views · 6 June 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,877 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,909 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 7:38 YouTubersLoveExcel#52: VLOOKUP & Workbook References

  excelisfun

  3,914 views · 7 July 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008