The SUMPRODUCT function checks for the non blank cells and sum ups the total count. The count is feed to INDEX that bring back the respective data from the array.
Category: Lookup and reference
Uses an index to choose a value from a reference or array
INDEX(array, row_num, [column_num])
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
SUMPRODUCT(array1, [array2], [array3], ...)
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM