SUM ">0" Values From Last 60 cells

[JonesyUK]

Hi All - please help:

I need to sum the last 3 NON-ZERO cells in a range of values, starting from the RIGHT to LEFT. example attached.

So for example: if range in first row is 2,4,0,6,8,0,10,4,0,0,3,2: then sum of last 3 non-zero numbers = 9 (i.e. 2+3+4)

Appreciate the help.

Thanks,

 

[JonesyUK]

Have found a solution: =SUMPRODUCT((COLUMN(A2:K2)>=LARGE(COLUMN(A2:K2)*(A2:K2>0),3))*(A2:K2))

Thanks All!