up to 255 total.
Arguments can be a hardcoded constant, a cell reference, or a range.
All numbers in the arguments provided are multiplied together.
Empty cells and text values are ignored.
error if any cells containtext.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
