=SUM(B2:INDEX(B2:B100,MATCH(TRUE,INDEX(B2:B100="", ),)))


"Tami" wrote:

can anyone write the formula to sum down to the first blank row it encounters?
In the sample data below I want the xx to sum only to 60
Assume the word sum is in cell A1 and the xx is in cell B1.

sum xx
Blue 10
Black 20
Red 30

Red 20
black 40

thanks much.

p.s. would this formula be considered "volatile" and therefore "risky"....if
so, what's the risk. thx.