INDEX(...)
Using SUMPRODUCT() to validate a criteria and INDEX() to retrive a value.
Used Functions
Category: Lookup and reference
Uses an index to choose a value from a reference or array
Syntax
INDEX(array, row_num, [column_num])
Practice INDEX Formula at Sheetzoom
INDEX formula at Microsoft helpCategory: Math and trigonometry
Returns the sum of the products of corresponding array components
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
0
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.