Media Summary: See how to check a range of cells for codes and then add associated numbers. See a Download Files: See how to use the SUMPRODUCT ... Download Files: See how to create a basic Attendance ...

Excel Magic Trick 466 Sum - Detailed Analysis & Overview

See how to check a range of cells for codes and then add associated numbers. See a Download Files: See how to use the SUMPRODUCT ... Download Files: See how to create a basic Attendance ... Download Files: See how to add all the sales for ...

Photo Gallery

Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions
Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column
Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formula
Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)
Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)
Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE
Excel Magic Trick 405: Quarterly Comparative Report  SUMPRODUCT function
Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting
Sponsored
Sponsored
View Detailed Profile
Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions

Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT466-471.xls See how to

Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column

Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column

Download

Sponsored
Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formula

Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formula

See how to check a range of cells for codes and then add associated numbers. See a

Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)

Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)

Download

Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)

Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)

Download

Sponsored
Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution

Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution

Download

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Download

Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE

Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE

Follow up video to

Excel Magic Trick 405: Quarterly Comparative Report  SUMPRODUCT function

Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT398-405.xls See how to use the SUMPRODUCT ...

Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!

Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT673-682.xlsm See how to use the SUMPRODUCT ...

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Download

Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting

Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT494-501.xls See how to create a basic Attendance ...

Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

Download

Excel Magic Trick 1041: Expandable Range In An Excel Table For Running Total (Zack Barresse's Trick)

Excel Magic Trick 1041: Expandable Range In An Excel Table For Running Total (Zack Barresse's Trick)

Download

Excel Magic Trick 1388 Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson)

Excel Magic Trick 1388 Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson)

(11:42) Summary Reference Videos:

Excel Magic Trick 305: SUM digits from string

Excel Magic Trick 305: SUM digits from string

Download

Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard

Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT615-622.xlsm See how to add all the sales for ...

Related Video Content

Office 365 login information

Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Save documents,...

Microsoft Excel - Download information

Feb 16, 2026 · Microsoft Excel is built for organizing data, running calculations, and turning tables into decisions....

Microsoft Excel: Spreadsheets - Apps on Google Play information

Spreadsheets & Calculations • Create charts, budgets, project plans, accounting & financial analysis with Excel's...

Microsoft Excel - App Store information

Download Microsoft Excel by Microsoft Corporation on the App Store. See screenshots, ratings and reviews, user tips,...

Download Microsoft Excel for Windows, macOS, Android, APK information

1 day ago · Microsoft Excel is a spreadsheet program from Microsoft and one of the core applications in the Microsoft...