Subtotal method of Range not working correctly

Hi all, newbie here. Have a problem which is driving me nuts, can anyone help? Thanks.

Here is the raw test data I am working with. There are 3 columns (I don't have field names).:

2432 afadfds BEGIN
32432 dfafdsf BEGIN
232323 fdsfdsfds WIN
23 dfsdf END
32 fdsfdsfds END

I run this code (to total the 1st column according to the 3rd column groups) :

Please Login or Register  to view this content.

And the result looks like this:

2432 afadfds BEGIN
32432 dfafdsf BEGIN
32432 BEGIN Total
232323 fdsfdsfds WIN
232323 WIN Total
23 dfsdf END
32 fdsfdsfds END
55 END Total
264810 Grand Total


The problem is that the BEGIN total hasn't added the first line value (2432) into the BEGIN total.