Looping excel function using VBA

Hello,
Can anyone help me with this function that I want to loop:

Please Login or Register  to view this content.

Here;s exapmle:
examplee.xlsx

Instead of "a lot" it should expand this formula up to reaching (24 + 0,xx) value, and it should work in different cells.
So I was thinking about something like creating

Please Login or Register  to view this content.

and then in VBA

Please Login or Register  to view this content.

and that's it.. I don't have idea how to go on with it, I think OFFSET could be useful but I don't have any specific idea how to use it. Maybe someone can give me a help and show me direction.

Thanks in advance,
Regards

Thanks nathansav, but I want it to be short, so it can be counted quickly if I'll put few thousands of this functions. Here's something what I came up with, but it has circular reference:

Please Login or Register  to view this content.

Ok, but it gives me Value in the cell on the right from B, and I want to give me SUM of them B.Value + B.Offset(0,1).Value etc. if you know what I mean.