Could someone help explain this formula?
=SUM(INDEX(B3:M3,1,MAX(1,C
OUNT(B3:M3)-2)):INDEX(B3:M3,1,COUNT(B3:M3)))
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:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26462331.html?cid=239#a33639089
Thanks for your help.
Like Sum (A1:A4) = it simply means the contiguous range of cells from A1 to A4 (4)
Or Sum( A1: B10 ) = 20 cells.
So Sum( <first index> : <second index> ) is no different.
You are getting col (3rd to last) and col (last) from B3:M3, so it will sum K3:M3