Thank you for your response. However, I am looking at making this more
flexible; there are more ranges to account for, like 5-8 where the number of
values will not always be constant.

Example:
1. 5,6,7,8
2. 5,7,8



"merjet" wrote:

MIN(D:D), MAX(D:D), SUM(E:E)

Put row numbers after column letters if desired.

Hth,
Merjet