Return on index formula
We can use the INDEX function to return an ARRAY of values to another function like the SUM function by integrating INDEX with the IF and N functions. We can use this to SUM values that are present in specific cells.This article will walk through the process. Figure 1: How to Sum/ Return an Array with the Index Function. Formula to Sum/ Return an Array with the Index Function