Sum data different size
 

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

Sum data different size
 

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

Sum data different size
 

On Tue, 30 Jun 2009 09:37:12 -0700 (PDT), 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

Try this formula:
You need an empty row before each section of data, also the first
section.

=IF(AND(A1="",A2<""),SUM(OFFSET(B2,,,MATCH(1,INDE X(--(B2:B$100=""),),0))),"")

The first part, the AND, is there to make the sum to appear just for
the first line in each section and not display any 0's below the
table.
It should be safe to copy this formula down as far as needed for any
future data size.

Hope this helps. / Lars-Åke