Sorry for the lack of clarity. If you don't mind, I'll try to explain it again. K27 asks Excel to sum columns 0100 & 0200 for lines 06300 to 09699. In doing so, the formula includes the values in columns 0100 & 0200 for line 09500. I would like the formula to sum 06300 to 09699 while excluding the 09500 values.

Hope this clarifies my request.

Thanks again.

Al