I see now. Well, if I were doing this I'd write a worksheet function after all. But there are some clever folks here at doing things with worksheet functions. Anyone else here want to take a whack at this?

If no one else chimes in, tandchas, I'll recommend writing your own personalized average function in VBA. Are you up for that? I more the teach-a-man-to-fish type, but there are some folks here who won't mind just writing one for you. Either way is fine; I understand that no everyone wants to take the time to learn a new skill.

(I'm not being sarcastic. I pay my sons to fix my car so I can concentrate on computers. I could to maintain my own car, but this is more fun.)