You're entitled to that view, of course, and I wasn't trying to suggest this was necessarily the best way of handling things; only showing that it could be done without resorting to named ranges. And, since neither of us knows the extent of the OP's data, I took the quick & dirty approach to showing how your formula could be adapted. Ideally, one would specify only as much of a range as is needed for the calculations.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]