Another one

Is there anyway I can stop a formula mid way through so for example if I was
looking to sum up the below numbers until it finds the 6 and then stops..

1
4
6
8
10

so the sum would be 11 and wouldnt continue to sum the 8 and 10 (these
fields would continually change so the 6 would not remain in the same place)

Cheers