SUM Column until blank cell is found

Originally Posted by daddylonglegs

Try this formula

=SUM(A1:INDEX(A:A,MATCH(TRUE,INDEX(A1:A1000="",0),0)))

EXCELLENT, I knew I could do it though VBA but I try to avoid doing that this work's great!

Thank you very much.

I also am trying to sum until a blank cell is reached but i want to have multiple sums in the column. I would like it to look like this (a sum of the In column ranges and a sum of the Trans column ranges:
Store Date Hour In Out Trans Sales Hours CR %
MONDAY
2 20110801 10 11 5 3 4.78 27.27%
2 20110801 11 13 18 8 4 61.54%
2 20110801 12 40 33 11 4 27.50%
2 20110801 13 55 65 10 4.05 18.18%
2 20110801 14 51 55 12 4.03 23.53%
2 20110801 15 51 63 14 5 27.45%
2 20110801 16 58 64 9 5 15.52%
2 20110801 17 46 45 4 4.47 8.70%
2 20110801 18 33 39 8 7.63 24.24%
2 20110801 19 44 53 4 5.08 9.09%
2 20110801 20 16 19 0 3.17 0.00%
TUESDAY 418 83 19.86%
2 20110802 10 8 12 2 5.42 25.00%
2 20110802 11 28 23 10 6 35.71%
2 20110802 12 52 42 13 6.07 25.00%
2 20110802 13 35 46 10 7 28.57%
2 20110802 14 33 41 6 6.97 18.18%
2 20110802 15 68 70 7 7 10.29%
2 20110802 16 68 68 7 7.02 10.29%
2 20110802 17 38 36 8 5.5 21.05%
2 20110802 18 23 29 3 5 13.04%
2 20110802 19 30 23 3 5 10.00%
2 20110802 20 4 8 0 4.63 0.00%
WENESDAY 387 69 17.83%
2 20110803 10 5 0 5 4 100.00%
2 20110803 11 35 35 3 4.08 8.57%
2 20110803 12 27 24 7 5 25.93%
2 20110803 13 37 43 8 5 21.62%
2 20110803 14 42 51 11 5 26.19%
2 20110803 15 39 40 7 4.17 17.95%
2 20110803 16 50 43 5 5.72 10.00%
2 20110803 17 27 45 6 5.02 22.22%
2 20110803 18 24 26 4 5 16.67%
2 20110803 19 16 20 3 5 18.75%
2 20110803 20 16 14 0 3.95 0.00%
THURSDAY 318 59 18.55%

I currently have this for the remaining of the column a new row which is blank and thats where i want the sum totals to go for In and Trans:
Store Date Hour In Out Trans Sales Hours CR %
3 20110808 10 17 8 6 7 35.29%
3 20110808 11 33 30 3 7 9.09%
3 20110808 12 45 48 9 8.68 20.00%
3 20110808 13 73 77 7 7.9 9.59%
3 20110808 14 68 64 11 7.77 16.18%
3 20110808 15 55 52 9 8 16.36%
3 20110808 16 51 50 3 8 5.88%
3 20110808 17 47 47 4 7.05 8.51%
3 20110808 18 23 24 2 7 8.70%
3 20110808 19 28 22 1 7 3.57%
3 20110808 20 22 35 1 6.77 4.55%
3 20110808 21 1 2 0 0 0.00%

3 20110809 10 13 7 7 3.9 53.85%
3 20110809 11 42 43 9 4 21.43%
3 20110809 12 60 61 8 4.35 13.33%
3 20110809 13 56 55 19 5.87 33.93%
3 20110809 14 89 91 10 6 11.24%
3 20110809 15 75 73 6 6 8.00%
3 20110809 16 43 49 3 5.63 6.98%
3 20110809 17 39 42 3 4.77 7.69%
3 20110809 18 19 31 2 4.98 10.53%
3 20110809 19 34 31 7 5 20.59%
3 20110809 20 23 26 0 4.25 0.00%

3 20110810 10 12 7 3 7 25.00%
3 20110810 11 42 40 6 7.02 14.29%
3 20110810 12 43 43 7 8 16.28%
3 20110810 13 17 24 3 8 17.65%
3 20110810 14 61 69 3 7.25 4.92%
3 20110810 15 41 45 4 6.3 9.76%
3 20110810 16 33 34 7 6.93 21.21%
3 20110810 17 43 54 11 5.92 25.58%
3 20110810 18 41 47 4 5.68 9.76%
3 20110810 19 51 54 5 6 9.80%
3 20110810 20 13 24 0 5.18 0.00%

3 20110811 10 11 8 6 4.8 54.55%
3 20110811 11 46 44 5 5.07 10.87%
3 20110811 12 30 24 5 6.57 16.67%
3 20110811 13 34 42 11 6.82 32.35%
3 20110811 14 82 83 7 6.63 8.54%
3 20110811 15 52 43 9 5.55 17.31%
3 20110811 16 57 63 7 4 12.28%
3 20110811 17 46 51 10 4.27 21.74%
3 20110811 18 56 59 3 4 5.36%
3 20110811 19 54 52 1 4 1.85%
3 20110811 20 15 14 0 3.22 0.00%

3 20110812 10 25 23 5 4 20.00%
3 20110812 11 33 51 5 3.78 15.15%
3 20110812 12 66 59 14 5.13 21.21%
3 20110812 13 63 67 8 6.53 12.70%
3 20110812 14 69 74 9 5.62 13.04%
3 20110812 15 73 73 10 5.18 13.70%
3 20110812 16 100 90 5 4.02 5.00%
3 20110812 17 76 76 8 3.4 10.53%
3 20110812 18 54 49 5 3.05 9.26%
3 20110812 19 37 38 3 3 8.11%
3 20110812 20 18 24 1 3 5.56%
3 20110812 21 2 5 0 0.1 0.00%

Hello,

I am trying to do the same thing. I have a column that looks like the attached.

I want to SUM all the numbers below the blank until it encounters the next blank.

The formula you made for the OP does not work in my case, any suggestions?

8-7-2015 6-52-55 AM.jpg

Originally Posted by daddylonglegs

Try this formula

=SUM(A1:INDEX(A:A,MATCH(TRUE,INDEX(A1:A1000="",0),0)))