I have about 10,000 rows of data. Will I have to do that manually? I just
need to somehow name the range between the CDU# and the line before the END
BALANCE #.

"TomPl" wrote:

I guess you wanted to include the CDU row so change the formulas to:

Enter the formula =sum(C1:C5) in cell C6
Enter the formula =sum(C8:C14) in cell C15

Tom