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
