Sum after blank cells

[checkQ]

Hello everyone,
I have a tricky situation. I have been entering numbers in column B (DR
column) and hoping that a formula in column C (CR) columns would sum the 200
& 300 to give 500, (C4). Also, if I entered 400,20 and 50 in column B, the
result of 470 would pop up in column C (C8). I have been trying many formulas
in column C but I keep getting 970... the sum of column B. Do I need a VBA?
A B C
1 DR CR
2 Advertising 200
3 Newsletters 300
4 Accounts pyable 500
5 Postage 400
6 Messenger 20
7 Stamps 50
8 Accounts pyable 470


500 IS C4
470 IS C8

 

[FSt1]

hi,
apparently the formula you are using now is summing all of the B column.
try this in C1
=sum(B2:B3)
and in C1
=sum(B5:B7)

there are other ways but if your data doesn't change, this will do.

Regards
FSt1

 

[Tyro]

In C4 put =C2+C3 or =SUM(C2:C3) and in C8 put =C5+C6+C7 (or =SUM(C5:C7)

Tyro

 

[Tyro]

I'm not really sure where you have your numbers. To me it looks like you
have the numbers 1-8 in column A, Names in column B and numbers in column C

Tyro

 

[checkQ]

I wish there was a way to display my data as it apperars on the excel sheet.
As soon as I post it on this forum the data gets all skewed.

Column A is are the texts ie Advertising, Newsletters. Column B are the DR's
200,300 &40,20,50. In Column Care the CR's 500 & 470. The numbers 1 to 8 are
the row numbers. If I add more numbers in Column B I would like column C to
sum all the numbers after the blank cell below 50. I expect to have at least
100 rows on my sheet/
Thanks for your quick response

 

[FSt1]

hi
forumla will expand and contract as you add row and delete rows provide that
you add or delete the row somewhere before the last row of the formula.

regards
FSt1