Would appreciate help for a simple worksheet

[e_a_g_l_e_p_i]

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

 

[DrSynapse]

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

 

[e_a_g_l_e_p_i]

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.

 

[Joe4]

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.

 

[thunter]

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.

 

[e_a_g_l_e_p_i]

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

 

[e_a_g_l_e_p_i]

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?

 

[Joe4]

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.

 

[e_a_g_l_e_p_i]

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

 

[e_a_g_l_e_p_i]

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