With the advent of Dynamic Array Excel in late 2018 the use of SUMPRODUCT is no longer needed unless you need to guarantee backwards compatibility.
What do you think?
The SUMPRODUCT function is a powerful tool in Excel that multiplies corresponding ranges or arrays and returns the sum of those products. It has been around since Excel 97, but with the introduction of new features like Power Query and Power Pivot, many users are wondering if it's still relevant.
The answer is yes—SUMPRODUCT can still be extremely useful for certain tasks. For example, it can quickly calculate weighted averages, which can be difficult to accomplish with other functions. However, there are some cases where more modern features may be better suited for certain data analysis tasks due to their greater flexibility and power.
Dec 10, 2022 — I'm trying to use SUMPRODUCT or any other formula to get an end calculation of how many ... Transferring ownership to dead wallet?
May 27, 2016 — I am asking for your help concerning weighted averages. You see, I have a table with Sales: sum(Volume) and Prices: sum(Prices)/sum(sales) as ...
Sep 27, 2018 — I'm putting together a SUMPRODUCT formula. ... =SUMPRODUCT( --(Table1[MS more than 40 days] = "Dead"), --(MONTH(Table1[Milestone Date ...