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,
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,