Question

What will be the result of the formula = count(c3:e7)

Answer 1

Answer:

. Final result: Lookup entire column. Final formula: =SUM(INDEX(C3:E7,0,MATCH(H2,C2:E2,0))) Syntax of the INDEX function = INDEX (array, row_num, column_num) The parameters are: array – a range of cells where we want to retrieve some data ; row_num – the row in the array from which we want to retrieve data