With reference to the SUMPRODUCT function, which of the following statements is true?
a.Any cell that does not satisfy the specified given condition or criteria will not be considered.
b.The arrays that appear as arguments must be of the same dimension.
c.The range of cells for each array must contain only nonzero values.
d.The array appearing as the first argument must be sorted in ascending order.