Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
How to count blank cells (Rows) between Non-Blank cells in Col "A" | Excel Discussion (Misc queries) | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions |