How can I sum/count a list until I hit a blank cell?

[taketwo]

I have my data laid out this way:

Job #1
Day 1
Day 2
(blank line)
Job #2
Day 1
Day 2
Day 3
Day 4
(blank line)
Job #3
Day 1
(blank line)

etc...

To the right are several columns of data that correspond to the work we did at each job. I also have several totals (both "sum" and "count"/"counta") where I have specified the ranges to add/count, beginning at "Day 1" for each job, and reaching to the blank cell.

Currently, I hit "autosum", and then drag the range from the first day until the blank line. Is there a way to simply place a formula on top of a column of numbers, and tell it to add/count until it reaches an empty cell? That would sure save a lot of time.

Thanks a lot.

[martindwilson]

sorry you want to total what? just job 1 ? i think you should perhaps put your data like this then you can use sum if sumif(a1:a100,"job #1",c1:c100)
Job #1
Job #1 Day 1
Job #1 Day 2

Job #2
Job #2 Day 1
Job #2 Day 2
Job #2 Day 3
Job #2 Day 4

Job #3
Job #3 Day 1
Job #3 Day 2

[DonkeyOte]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.