C2:C11 contains numerical numbers either 0 or a +ve number
In this above range i.e. C2:C11, a series of cells contains 'same' numbers (in the example: C6:C11)
Output cell: F2=Average of above numbers (here average of C2:C5)
Note: IF C10 (2nd last number) is not equal to C11 (last number), then F2=Average of C2:C11
IF any of C2:C11='0' then F2=0
How to accomplish?
Thanks in advance