=SUMPRODUCT(MID(G2,{1;2;3},1)*1) I found this formula in a notebook. Can you understand it’s purpose? I’ll explain it in this post. I’ll also expand it for a more complex case. Continue reading
What is this formula doing?
Posts Tagged → sumproduct
Allocating costs
In this post I’ll show you how to allocate expenses (or any number) over a period of time. I will use years but it could also be months, weeks or days. Continue reading
Who Won the 2018 Winter Olympics?
I watched the closing ceremonies of the Olympics last night. It was very nice…but who won the Olympics? Continue reading
Rank within Groups in Excel
How can we rank within groups in Excel? Most experts will tell you to use the SUMPRODUCT function. Why? It’s the only solution they know or maybe they’re concerned about compatibility. Is anyone still using Excel 2003? Let’s compare SUMPRODUCT and COUNTIFS. Continue reading
Video 00011 SUMPRODUCT_Part3 How it really works!
Learn what Excel’s sumproduct function is really doing. See what’s going on inside by evaluating it.
Remember this: the F9 key is your friend! Continue reading
Video 00010 SUMPRODUCT_Intro_Part2
A quick review of the Sumproduct function and 2 more examples. Continue reading
Video 00002 SUMPRODUCT_function Part1
Many people have asked me about Excel’s sumproduct function. It is one of Excel’s most versatile and useful functions. Here is an introduction video. Continue reading