perl -lanF, -e '$total += $F[6]; $sub += $F[6]; print "Subtotal: $sub" and $sub = 0 if eof; print "Total: $total" if eof()' in1.csv in2.csv
Subtotal: 23789
Subtotal: 25085
Total: 48874