Could someone help explain this formula?
The first Index will find the value in the Max Count of cells (-2) in the array that are Numeric. Let's say it's column 6 = value 300.
The second Index does the same but without the "-2", so that's column 8 = value 200.
Those are two values that could be added with a "+". But the goal of this formula (it does work) is to SUM the range of values from column 6 to column 8.
This SUM command connects(?) the two Indexes with a ":" -- how does the formula know that means get all of the cells between the two index values?
This question is based on this one:
Thanks for your help.