Hello,
I have percentages in column A, and values in column B.
The numbers are organised by groups separated by blank cells. I want to be
able to sum clusters in B based on values in A with the following exception
Sum all values Except when there are multiple occurences of 80%, stop at the
first occurence of 80%

For instance,
From A2 to A5: 30%,60%,80%,80%
From B2 to B5: 12,13,24,56
will give (12+13+24) in B1

A8:100%
B8:45
will give (45) in B7

From A12 to A14:80%,80%,80%
From B12 to B14:13,78,23
will give (13) in B11
Etc

Any idea very welcome
Thank you

--
caroline