Would appreciate help for a simple worksheet

E

e_a_g_l_e_p_i

New Member
Joined
Dec 12, 2012
Messages
23
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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
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
 
Upvote 0
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:
Upvote 0
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.
 
Upvote 0
e_a_g_l_e_p_i said:
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.
Click to expand...

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.
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
Joe4 said:
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.
Click to expand...

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:
Upvote 0
Joe4 said:
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.
Click to expand...

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
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
How to subtract a named range from a formula
Replies
8
Views
132
Burrgogi
B
K
  • Question
Populate column C with repeated entries based on count for each row in column A?
Replies
3
Views
109
Peter_SSs
Peter_SSs
A
  • Question
Conditional summing more complex than my brain
Replies
2
Views
131
Fluff
Fluff
N
  • Question
Multiple Item Data Validation List Used For Sum Criteria
Replies
0
Views
285
Nailbender31
N
A
  • Question
Help with scanning barcodes into an excel invoice
2
Replies
12
Views
608
RoryA
RoryA

Forum statistics

Threads
1,215,059
Messages
6,122,918
Members
449,094
Latest member
teemeren

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top