I think if you enter a zero, it does put it into the average, but if you leave it blank that it does not. I could be wrong, though. I bet arthurd knows!
Yes, that does seem to be the case.
Thanks - changed! I don't think it has always worked that way because I've tried the zero before but it definitely works now.