Hi - Dave here.
As you spend more time working with Excel formulas, you'll start to run into the SUMPRODUCT function a lot. Why does the SUMPRODUCT function show up in so many Excel formulas?
In this article, I attempt to explain why you see SUMPRODUCT so often in formulas, and when you can use the SUM function instead.
[
download the workbook and read the full explanation]
The screens above show an example from the article. Download the workbook and have a look. This is a confusing topic, but it is important if you want to understand more advanced formulas in Excel.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
