How do I sum the last 5 nonzero numbers in a row?
Francis wrote:
I have misread your request, you want to sum the last five non zero columns
instead of rows, try this array formula in U2 ( the 21st column), confirm by
Ctrl, Shift and Enter
=SUM(T2:INDEX(A2:T2,LARGE(COLUMN(A2:T2)*(A2:T2<0) ,5)))
Please ignore my post, this answers my question (and the OP's).
|