Excel sum values, but I can't use SUM function - 10 crazy methods
Excel's SUM function is vital. But I can't use it. So how can you sum up a range of values when you are not allowed to use SUM function. In this crazy video, let me show you 10 insane methods to add up a bunch of numbers using Excel, all without ever using SUM or + symbol.
Download the file with the formulas
=============================
https://chandoo.org/wp/wp-content/uploads/2021/01/sum-but-dont-sum.xlsx
Video timestamps
===============
0:00 Intro to the challenge
1:11 - using average times count
1:46 - sumproduct
2:42 - trimmean times count
3:48 - subtotal
4:38 - aggregate
5:28 - mmult
7:33 - imsum
8:11 - npv
9:24 - seriessum
10:10 - harmean
12:18 - closing remarks
So which one do you like the most? Please share your own whacky ways to sum numbers when you cannot use SUM() or + operator in the comments.
#ExcelSUM #ExcelChallenges
Видео Excel sum values, but I can't use SUM function - 10 crazy methods канала Chandoo
Download the file with the formulas
=============================
https://chandoo.org/wp/wp-content/uploads/2021/01/sum-but-dont-sum.xlsx
Video timestamps
===============
0:00 Intro to the challenge
1:11 - using average times count
1:46 - sumproduct
2:42 - trimmean times count
3:48 - subtotal
4:38 - aggregate
5:28 - mmult
7:33 - imsum
8:11 - npv
9:24 - seriessum
10:10 - harmean
12:18 - closing remarks
So which one do you like the most? Please share your own whacky ways to sum numbers when you cannot use SUM() or + operator in the comments.
#ExcelSUM #ExcelChallenges
Видео Excel sum values, but I can't use SUM function - 10 crazy methods канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explainedAwesome Power Query example - Calendar data to table format 📅➡📄Employee Shift Tracker Excel Template - How it worksConvert number to words with this Excel formula + LET Function DemoMay the Power BI with you - Demo of Star Wars Infographic🧇 Yummy WAFFLE Chart in Power BI - How to make one?How to do weighted sorting in Excel?Celebrate Halloween with Creepy Spider Web Chart in ExcelKNOW the difference between AVERAGE // MEDIAN // QUARTILES - Easy explanation 👌How to create a fully *INTERACTIVE* and AWESOME Dashboard in Excel (PART 2)How to split text values in Excel with formulas - Quick Solution ⏳DAX Concepts: How to Create Best in Category Calculations with EaseAverage calculation in Excel, but with a twist 🥨Where to get FREE Datasets to practice Data AnalyticsTry this yummy Lollipop Chart 🍭 (Excel trick)Easiest Lookup formulas for any situation - an interview with Oz Du Soliel (Excel on Fire)Can you split The Hangover expenses using Excel?6 Massively time saving Pivot Table tricks (Don't miss #4 & #6) ⏰Data Analyst Job Interview - Don't make these 7 mistakesHow to connect to Amazon AWS S3 Buckets from Power BI - Step by Step Tutorial (with code samples)Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...