On Jun 30, 9:37*am, Pamela wrote:
Hi Guys,

I have a spreedsheet that looks like this:
Column A * *Column B * ColumnC
XXXX * * * * * *1000 * * * * * HERE I want the sum result
YYY * * * * * * 1200
ZZZZ * * * * * * 1100
blank
XXXX * * * * * * *1000 * * * * HERE I want the sum result
YYY * * * * * * * 1000
blank
ZZZ * * * * * * * * *500 * * * * HERE I want the sum result

I am trying to find a formula to sum column B up to the blank since
column B can vary sizes I don't how to tell the formula to sum until
there is a blank and place the result in the first row of the data
range in column C (HERE I want the sum result).
please help me

XOXOXOX
Pamela

Forget about it I solve it!!! =SUMPRODUCT(OFFSET(N5,,,MATCH
(TRUE,N5:N1002="",)))

Thank you http://www.eggheadcafe.com