Sum data different size

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

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

Thank you http://www.eggheadcafe.com
 
L

Lars-Åke Aspelin

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,INDEX(--(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top