Quote Originally Posted by chaz
Bryan,
Wouldn't using references like B2:B6 make the formula break when new rows of data are added?
-chaz
Of course, but the response was to your request, which indicated a header row and five rows of data, thus the formula, a guide as to 'how-to', is written to match yor example.

Adjust the range of the formula to suit your needs.

---