Sum after blank cells
 

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

Sum after blank cells
 

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

"checkQ" wrote:

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

Sum after blank cells
 

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

Tyro

"checkQ" wrote in message
...
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

Sum after blank cells
 

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
"Tyro" wrote in message
. ..
In C4 put =C2+C3 or =SUM(C2:C3) and in C8 put =C5+C6+C7 (or =SUM(C5:C7)

Tyro

"checkQ" wrote in message
...
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

Sum after blank cells
 

Sum after blank cells
 

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

Sum after blank cells
 

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

"checkQ" wrote:

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