Thanks. That makes sense. But I am disappointed in how Excel created the formula using "SUBTOTAL" when I hit the SUM button on the toolbar. That was not entered by me. It was only when the results started changing that I tracked it down and discovered the use of SUBTOTAL. Thanks again.