Spreadsheet: 49843d1249279570-sum-values-in-a-dynamic-range-contiguous-cells-in-a-table-example
Sheet: Actuals

Actuals
Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Comments | Job comments
TOTALS |  |  |  |  | 1367142 |  | TOTALS
 |  |  |  |  | 7327 |  | 1
 |  |  |  |  | 915 |  | 1
 |  |  |  |  | 6136 |  | 1
 |  |  |  |  | 5404 |  | 1
 |  |  |  |  | 7281 |  | 1
 |  |  |  |  | 4430 |  | 1
 |  |  |  |  | 2474 |  | 1
 |  |  |  |  | 8095 |  | 1
 |  |  |  |  | 6043 |  | 1
 |  |  |  |  | 7845 |  | 1
 |  |  |  |  | 7252 |  | 1
 |  |  |  |  | 456 |  | 1
 |  |  |  |  | 7424 |  | 1
 |  |  |  |  | 8907 |  | 1
 |  |  |  |  | 1517 |  | 1
 |  |  |  |  | 2959 |  | 1
 |  |  |  |  | 5784 |  | 1
 |  |  |  |  | 5190 |  | 1
 |  |  |  |  | 9262 |  | 1
 |  |  |  |  | 3605 |  | 1
 |  |  |  |  | 4867 |  | 1
 |  |  |  |  | 4972 |  | 2
 |  |  |  |  | 7947 |  | 2
 |  |  |  |  | 4233 |  | 2
 |  |  |  |  | 4412 |  | 2
 |  |  |  |  | 3788 |  | 2
 |  |  |  |  | 20 |  | 2
 |  |  |  |  | 8751 |  | 2
 |  |  |  |  | 9738 |  | 2
 |  |  |  |  | 8842 |  | 2
 |  |  |  |  | 6774 |  | 2
 |  |  |  |  | 5687 |  | 2
 |  |  |  |  | 1797 |  | 2
 |  |  |  |  | 9290 |  | 2
 |  |  |  |  | 8448 |  | 2
 |  |  |  |  | 6038 |  | 2
 |  |  |  |  | 1596 |  | 2
 |  |  |  |  | 1938 |  | 2
 |  |  |  |  | 1834 |  | 2
 |  |  |  |  | 9638 |  | 2
 |  |  |  |  | 5651 |  | 2
 |  |  |  |  | 9720 |  | 2
 |  |  |  |  | 9290 |  | 2
 |  |  |  |  | 1759 |  | 2
 |  |  |  |  | 9869 |  | 2
 |  |  |  |  | 4372 |  | 2
 |  |  |  |  | 1924 |  | 3
 |  |  |  |  | 4910 |  | 3
 |  |  |  |  | 6020 |  | 3
 |  |  |  |  | 4631 |  | 3
 |  |  |  |  | 4921 |  | 3
 |  |  |  |  | 6441 |  | 3
 |  |  |  |  | 7410 |  | 3
 |  |  |  |  | 4659 |  | 3
 |  |  |  |  | 4799 |  | 3
 |  |  |  |  | 5841 |  | 3
 |  |  |  |  | 6460 |  | 3
 |  |  |  |  | 8183 |  | 3
 |  |  |  |  | 4341 |  | 3
 |  |  |  |  | 4407 |  | 3
 |  |  |  |  | 7797 |  | 3
 |  |  |  |  | 7526 |  | 3
 |  |  |  |  | 8 |  | 3
 |  |  |  |  | 6213 |  | 3
 |  |  |  |  | 2440 |  | 3
 |  |  |  |  | 2271 |  | 3
 |  |  |  |  | 1896 |  | 3
 |  |  |  |  | 6665 |  | 3
 |  |  |  |  | 1734 |  | 3
 |  |  |  |  | 6279 |  | 3
 |  |  |  |  | 7596 |  | 3
 |  |  |  |  | 658 |  | 3
 |  |  |  |  | 5216 |  | 3
 |  |  |  |  | 2020 |  | 3
 |  |  |  |  | 5096 |  | 3
 |  |  |  |  | 9058 |  | 4
 |  |  |  |  | 7066 |  | 4
 |  |  |  |  | 8280 |  | 4
 |  |  |  |  | 350 |  | 4
 |  |  |  |  | 5904 |  | 4
 |  |  |  |  | 9987 |  | 4
 |  |  |  |  | 1409 |  | 4
 |  |  |  |  | 3033 |  | 4
 |  |  |  |  | 7521 |  | 4
 |  |  |  |  | 7981 |  | 4
 |  |  |  |  | 5591 |  | 4
 |  |  |  |  | 5752 |  | 4
 |  |  |  |  | 4899 |  | 4
 |  |  |  |  | 8738 |  | 4
 |  |  |  |  | 199 |  | 4
 |  |  |  |  | 5765 |  | 4
 |  |  |  |  | 1529 |  | 4
 |  |  |  |  | 4321 |  | 4
 |  |  |  |  | 9684 |  | 4
 |  |  |  |  | 5346 |  | 4
 |  |  |  |  | 7945 |  | 4
 |  |  |  |  | 5200 |  | 4
 |  |  |  |  | 9398 |  | 4
 |  |  |  |  | 5026 |  | 4
 |  |  |  |  | 1317 |  | 4
 |  |  |  |  | 8841 |  | 4
 |  |  |  |  | 4247 |  | 4
 |  |  |  |  | 80 |  | 5
 |  |  |  |  | 8913 |  | 5
 |  |  |  |  | 899 |  | 5
 |  |  |  |  | 3536 |  | 5
 |  |  |  |  | 2749 |  | 5
 |  |  |  |  | 2950 |  | 5
 |  |  |  |  | 5862 |  | 5
 |  |  |  |  | 1699 |  | 5
 |  |  |  |  | 328 |  | 5
 |  |  |  |  | 8601 |  | 5
 |  |  |  |  | 8693 |  | 5
 |  |  |  |  | 3582 |  | 5
 |  |  |  |  | 2346 |  | 5
 |  |  |  |  | 2807 |  | 5
 |  |  |  |  | 2434 |  | 5
 |  |  |  |  | 690 |  | 5
 |  |  |  |  | 1286 |  | 5
 |  |  |  |  | 8588 |  | 5
 |  |  |  |  | 9819 |  | 5
 |  |  |  |  | 186 |  | 5
 |  |  |  |  | 6709 |  | 5
 |  |  |  |  | 8095 |  | 5
 |  |  |  |  | 646 |  | 5
 |  |  |  |  | 3527 |  | 5
 |  |  |  |  | 5860 |  | 5
 |  |  |  |  | 6908 |  | 5
 |  |  |  |  | 659 |  | 6
 |  |  |  |  | 3143 |  | 6
 |  |  |  |  | 4317 |  | 6
 |  |  |  |  | 5631 |  | 6
 |  |  |  |  | 8218 |  | 6
 |  |  |  |  | 7095 |  | 6
 |  |  |  |  | 7779 |  | 6
 |  |  |  |  | 2127 |  | 6
 |  |  |  |  | 3107 | 175.99 | 6
 |  |  |  |  | 6072 |  | 6
 |  |  |  |  | 2047 |  | 6
 |  |  |  |  | 1423 |  | 6
 |  |  |  |  | 6528 |  | 6
 |  |  |  |  | 963 |  | 6
 |  |  |  |  | 490 |  | 6
 |  |  |  |  | 3050 |  | 6
 |  |  |  |  | 5674 |  | 6
 |  |  |  |  | 3753 | 866.66 | 6
 |  |  |  |  | 4390 |  | 6
 |  |  |  |  | 8571 |  | 6
 |  |  |  |  | 7498 |  | 6
 |  |  |  |  | 8959 |  | 6
 |  |  |  |  | 7399 |  | 6
 |  |  |  |  | 9783 |  | 6
 |  |  |  |  | 4949 |  | 6
 |  |  |  |  | 6182 |  | 6
 |  |  |  |  | 2988 |  | 6
 |  |  |  |  | 8427 |  | 6
 |  |  |  |  | 2405 |  | 6
 |  |  |  |  | 2774 |  | 6
 |  |  |  |  | 6639 |  | 7
 |  |  |  |  | 1631 |  | 7
 |  |  |  |  | 6728 |  | 7
 |  |  |  |  | 7071 |  | 7
 |  |  |  |  | 1520 |  | 7
 |  |  |  |  | 7859 |  | 7
 |  |  |  |  | 2588 |  | 7
 |  |  |  |  | 7422 |  | 7
 |  |  |  |  | 8177 |  | 7
 |  |  |  |  | 1498 |  | 7
 |  |  |  |  | 9870 |  | 7
 |  |  |  |  | 9813 |  | 7
 |  |  |  |  | 4206 |  | 7
 |  |  |  |  | 802 |  | 7
 |  |  |  |  | 5935 |  | 7
 |  |  |  |  | 7086 |  | 7
 |  |  |  |  | 7367 |  | 7
 |  |  |  |  | 685 |  | 7
 |  |  |  |  | 9103 |  | 7
 |  |  |  |  | 9630 |  | 7
 |  |  |  |  | 2792 |  | 7
 |  |  |  |  | 5998 |  | 7
 |  |  |  |  | 9852 |  | 7
 |  |  |  |  | 8474 |  | 7
 |  |  |  |  | 4606 |  | 7
 |  |  |  |  | 1370 |  | 7
 |  |  |  |  | 1243 |  | 7
 |  |  |  |  | 5929 |  | 7
 |  |  |  |  | 4960 |  | 7
 |  |  |  |  | 695 |  | 7
 |  |  |  |  | 8129 |  | 8
 |  |  |  |  | 2001 |  | 8
 |  |  |  |  | 579 |  | 8
 |  |  |  |  | 6271 |  | 8
 |  |  |  |  | 1743 |  | 8
 |  |  |  |  | 854 |  | 8
 |  |  |  |  | 9587 |  | 8
 |  |  |  |  | 6046 |  | 8
 |  |  |  |  | 3483 |  | 8
 |  |  |  |  | 6025 |  | 8
 |  |  |  |  | 8067 |  | 8
 |  |  |  |  | 8538 |  | 8
 |  |  |  |  | 9912 |  | 8
 |  |  |  |  | 5645 |  | 8
 |  |  |  |  | 4793 |  | 8
 |  |  |  |  | 8481 |  | 8
 |  |  |  |  | 3952 |  | 8
 |  |  |  |  | 672 |  | 8
 |  |  |  |  | 5532 |  | 8
 |  |  |  |  | 4555 |  | 8
 |  |  |  |  | 9445 |  | 8
 |  |  |  |  | 4465 |  | 8
 |  |  |  |  | 9808 |  | 8
 |  |  |  |  | 6602 |  | 8
 |  |  |  |  | 6435 |  | 8
 |  |  |  |  | 8409 |  | 8
 |  |  |  |  | 8208 |  | 9
 |  |  |  |  | 7425 |  | 9
 |  |  |  |  | 9479 |  | 9
 |  |  |  |  | 8817 |  | 9
 |  |  |  |  | 6604 |  | 9
 |  |  |  |  | 8499 |  | 9
 |  |  |  |  | 6566 |  | 9
 |  |  |  |  | 3365 |  | 9
 |  |  |  |  | 6015 |  | 9
 |  |  |  |  | 974 |  | 9
 |  |  |  |  | 3032 |  | 9
 |  |  |  |  | 699 |  | 9
 |  |  |  |  | 7366 |  | 9
 |  |  |  |  | 1099 |  | 9
 |  |  |  |  | 1429 |  | 9
 |  |  |  |  | 6578 |  | 9
 |  |  |  |  | 7906 |  | 9
 |  |  |  |  | 8603 |  | 9
 |  |  |  |  | 9707 |  | 9
 |  |  |  |  | 7539 |  | 9
 |  |  |  |  | 4299 |  | 9
 |  |  |  |  | 2219 |  | 9
 |  |  |  |  | 243 |  | 9
 |  |  |  |  | 6680 |  | 9
 |  |  |  |  | 4879 |  | 9
 |  |  |  |  | 7236 |  | 9
 |  |  |  |  | 5365 |  | 9
 |  |  |  |  | 3996 |  | 9
 |  |  |  |  | 4693 |  | 9
 |  |  |  |  | 7126 |  | 9
 |  |  |  |  | 3384 |  | 9
 |  |  |  |  | 8257 |  | 10
 |  |  |  |  | 1010 |  | 10
 |  |  |  |  | 7530 |  | 10
 |  |  |  |  | 7163 |  | 10
 |  |  |  |  | 5109 |  | 10
 |  |  |  |  | 4803 |  | 10
 |  |  |  |  | 7986 |  | 10
 |  |  |  |  | 1749 |  | 10
 |  |  |  |  | 3290 |  | 10
 |  |  |  |  | 7270 |  | 10
 |  |  |  |  | 3098 |  | 10
 |  |  |  |  | 1513 |  | 10
 |  |  |  |  | 6345 |  | 10
 |  |  |  |  | 9883 |  | 10
 |  |  |  |  | 4008 |  | 10