P
Pamela
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
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