The array consists of a sequence of consecutive values in a certain range. So when calculating the array that we work with the elements in the array, the SUMPRODUCT function in Excel helps you ...