automatically adding up data from large table

Hello,

I have a small problem, and I think that there is an easy solution, but I can't find anything.

I have data in excel like this:

---A B C
1- 1 3 5
2- 2 3 6
3- 4 7 8
4- 6 6 3
5- 8 7 9
6- 9 2 8
7-
8- 34 78 56
9- 45 56 82
10- 67 68 97
11- 54 35 75
12- 56 25 91

(and the list goes on, with more numbers to both the bottom and the right), and what I want is to add-up the values of each column B and C for A1:6 and A8:12...

The 'blocks' are of different lenghts down, but of equal length to the right, and are always separated with an empty cell down, like in the example.
Is there someone who can help?
I hope I'm clear...

Domski, thank you so much, you are a genius!! Been thinking about a solution for this for a while, but this is incredibly helpful from you!
If I ever meet you in a pub, I'll buy you a pint (or two)...

I'll now try to understand what the macro does, so I can use it in the future.

Thanks again,

Arjen

Originally Posted by Domski

No worries, I'll be in The Fleece in Farsley tonight

If you want me to add some comments to the code as to what it's doing let me know.

For info this doesn't do anything useful and can be removed:

Please Login or Register  to view this content.

I just popped it in so I could see what was happening while I tested it.

Dom

Unfortunately I'm stuck in the former DDR (which normally isn't much fun, but if Germany loses in footy... )....

Anyway, I'll try to figure the macro out over the weekend, still need to get stuff done now.

Originally Posted by Domski

No worries, I'll be in The Fleece in Farsley tonight

If you want me to add some comments to the code as to what it's doing let me know.

For info this doesn't do anything useful and can be removed:

Please Login or Register  to view this content.

I just popped it in so I could see what was happening while I tested it.

Dom

I have a very stupid question - how can I expand the range of columns? Now the script does the job for columns B and C, but I'd like to include up to column AV or something - is this possible? I've tried to make the ranges a bit wider (from B1:B to B1:AV for example), but that all just spits out bollocks...

or:

Please Login or Register  to view this content.