I have a slightly complex problem I'm trying to figure out in excel. I need a simple moving average, lets say for a period of 3, however, I only want it to average negative or positive numbers in the range. So, in other words, say we're only averaging negatives in this range (-5,-4,-6) we would get a return of -5. But lets say the next number is a positive (-5,-4,-6,3), I still need it to return -5 by completely over looking the positive integers and only looking at the last 3 negative ones. And again, if the range continued to this (-5,-4,-6,3,-8), we should get -6. Is this possible??