# Would appreciate help for a simple worksheet

#### e_a_g_l_e_p_i

##### New Member
I would like to keep a work sheet that has the dates in A column. one item in B column and another item in column C.

Then in column D I want a running total of column B and in column E want a running total of column C

Somehow I would like to have a starting count for each columns B&C and then the rest of the worksheet will keep a running count as described above.

If I have not be clear as to what I want, I have 2 items and want to keep a daily running count of each item.

Thanks in advance to everyone who replies to my post

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
If you'd like a starting count for columns B & C, you could embedd that in the formula of column D & E....

ColumnD= 10+Sum(B1:B10)

Hopefully this helps in terms of the starting count portion

Regards,
Anthony

Thanks.. that isn't what I am looking for. I was afraid I didn't explain it well. I will try it again and be more detailed.

I want to set up a work sheet that keeps a running total count of 2 items, (for example I'll use apples & oranges)

Date in column A
Apples in column B
Oranges in column C

As I sell apples or oranges I will enter a total for each date in the appropriate column, each row will be a different date. Somewhere I need a cell to keep a current total so the total in the cell will update as I sell apples or oranges each day. It would also be nice to have a way to add new supplies to the current total.

I need the formulas or whatever is used for each cells.

Last edited:
OK, let's say that in row 2 you are going to have your "starting" values.
First, enter the following formulas:
In cell D2: =B2
In cell E2: =C2

Then let's say that your daily values are starting to be entered on row 3, and below.
For your running totals, enter the following formulas:
In cell D3: =D2 + B3
In cell E3: =E2 + C3
and copy down for all rows these formulas down for all your data rows.

Thanks.. that isn't what I am looking for. I was afraid I didn't explain it well. I will try it again and be more detailed.

I want to set up a work sheet that keeps a running total count of 2 items, (for example I'll use apples & oranges)

Date in column A
Apples in column B
Oranges in column C

As I sell apples or oranges I will enter a total for each date in the appropriate column, each row will be a different date. Somewhere I need a cell to keep a current total so the total in the cell will update as I sell apples or oranges each day. It would also be nice to have a way to add new supplies to the current total.

I need the formulas or whatever is used for each cells.

I am sure there aer other ways, but this is what I came up with off the top of my head.

Date Apples Oranges Running Total
8/1/2014 1 5 =Sum(C2:C2)
8/2/2014 2 3 =SUM(B\$2:B3)+SUM(C\$2:C3)

Then just copy down the formula. Like I said, I am sure there are better ways of doing this but this was the first thing that popped into my head.

Thanks to all of you I will try each way and get back with you.

I couldn't get either to work for me, I'm sure it is me not being sure what I am doing. Let me try again.

In A3 I will have the dates, I know how to do that......lol
in B3 I will put the starting number of apples I have
In C3 I will put the starting number of oranges I have
Then in all the other B and C rows each day I will enter in those cells the amount I sell or the number I add to my totals

I want the cell B3 and C3 to update as I put the numbers in of each cell from B4 and C4 down to the end of those columns.

Does this make better sense?

That is essentially what the methods we proposed to you do. Note that since your are putting your starting values on line 3 instead of on line 2 in my example, you would just need to move everything down one row.

How exactly is it not working for you?
Is the issue is you do not want to actually type/copy these formulas in, that you want it to happen automatically, by itself?
If so, you have two options:

1. To use VBA. This is really the only way to make things happen automatically upon some event happening. Are you open to using VBA?

2. Pre-populate all your formulas, but have them return nothing until a value exists in column A, i.e.
in cell D4: =IF(A4>0,D3+B4,"")
in cell E4: =IF(A4>0,E3+C4,"")
If you enter those formulas on row 4, and copy down for all possible row you may ever have, nothing will show up in these columns until column A of that row is populated.

That is essentially what the methods we proposed to you do. Note that since your are putting your starting values on line 3 instead of on line 2 in my example, you would just need to move everything down one row.

How exactly is it not working for you?
Is the issue is you do not want to actually type/copy these formulas in, that you want it to happen automatically, by itself?
If so, you have two options:

1. To use VBA. This is really the only way to make things happen automatically upon some event happening. Are you open to using VBA?

2. Pre-populate all your formulas, but have them return nothing until a value exists in column A, i.e.
in cell D4: =IF(A4>0,D3+B4,"")
in cell E4: =IF(A4>0,E3+C4,"")
If you enter those formulas on row 4, and copy down for all possible row you may ever have, nothing will show up in these columns until column A of that row is populated.

I tried again and nothing happens. I copied your formulas and then dragged them all the way down past any cell in those 2 columns that I would ever use somewhere around row 5000. but nothing happens. I know nothing about VBA but willing to try.

I think I am not explaining what I need well enough. ???? when you say pre-popular I am not sure of what you mean by that??

Last edited:
That is essentially what the methods we proposed to you do. Note that since your are putting your starting values on line 3 instead of on line 2 in my example, you would just need to move everything down one row.

How exactly is it not working for you?
Is the issue is you do not want to actually type/copy these formulas in, that you want it to happen automatically, by itself?
If so, you have two options:

1. To use VBA. This is really the only way to make things happen automatically upon some event happening. Are you open to using VBA?

2. Pre-populate all your formulas, but have them return nothing until a value exists in column A, i.e.
in cell D4: =IF(A4>0,D3+B4,"")
in cell E4: =IF(A4>0,E3+C4,"")
If you enter those formulas on row 4, and copy down for all possible row you may ever have, nothing will show up in these columns until column A of that row is populated.

In this image it shows what I need, the red numbers need to update as I enter numbers below those 2 columnshttp://www.usedissues.com/images/excel.jpg

Replies
0
Views
113
Replies
1
Views
114
Replies
9
Views
373
Replies
12
Views
286
Replies
3
Views
230

1,203,460
Messages
6,055,553
Members
444,796
Latest member
18ecooley

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back