SUMPRODUCT(...)+1

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

SUMPRODUCT(array1, [array2], [array3], ...)

Category: Math and trigonometry

Returns a subtotal in a list or database

SUBTOTAL(function_num,ref1,[ref2],...)

Category: Lookup and reference

Returns a reference offset from a given reference

OFFSET(reference, rows, cols, [height], [width])

Category: Lookup and reference

Returns the row number of a reference

ROW([reference])

0

Calculates dynamic rank for visible cells given all the numbers are positive. The SUMPRODUCT function is an array and it will calculate for each row found in ROW(C2:C6)Given the sheet is filtered and only Region A is visible.