The SUMPRODUCT function is a powerful tool that performs multiple calculations in a single step without needing helper columns. It is ideal for calculating weighted averages or total sales values.
Сделать с помощью ИИSelect the target cell
Click on the cell where you want the final result to appear.
Enter the SUMPRODUCT formula
Type '=SUMPRODUCT(' followed by the first array range, a comma, and the second array range.
Close the parenthesis and calculate
Type ')' to close the function and press Enter to see the calculated result.
=SUMPRODUCT(array1, array2, ...)No, SUMPRODUCT is designed to handle arrays natively and works with a standard Enter press.