For each cell in loop, find cells that contain the same in range and sum cor. matches

Hi

I have a little tricky excel thing that im struggling with. And i have been using the forum for alot of tricky things before that other people as well has struggled with. So hopefylly this time my post will help me and others as well.

I wanna loop true a range like this and sum corrosponding cells if value in this range is from right is 0.1, 0.2 and so on.
COL.B
1.0
1.0.1
1.1
1.2
1.3
1.4
1.4.0.1
1.4.1
1.4.1.0.1
1.5
1.5.0.1
1.6

Example: If cell value is 1.0 i want it to sum all cells in column S that is 1.0.1, 1.0.2 in column B and so on until 1.0 is no longer 1.0.x.x.x. And place the sum in 1.0 column T
The same if cell value is 1.4 i want to sum all cells in column S that is 1.4.0.1, 1.4.0.2 in column B and so on until 1.4 is no longer 1.4.0.x.x. And place the sum in 1.4 column T

Almost forgott, the range in column B can also be:
1.4.1
1.4.1.0.1
1.5
1.5.0.1
1.4.1
1.4.1.0.1

So the numbers can repeat so the loop that search for matches has to stop when the number is no longer.
And on the top of this the numbers are formatted as text.

I hope this made any sense. Im not sure if i understand what i wanna do.

To attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

The description to not correspond to the workbook; however, for the case of "1.0" in column C:

Please Login or Register  to view this content.

If you had posted a more accurate workbook a couple of dynamic ranges could be easily setup.