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

 

[Fluff]

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

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.

Which of these do you actually want, or both?

Question already answered

 

[Fluff]

In B1 put your starting quantity & then
in B2 put =B1-Sum(B4:B5000)
& the same for C2

 

[e_a_g_l_e_p_i]

In B1 put your starting quantity & then
in B2 put =B1-Sum(B4:B5000)
& the same for C2

I am so Frustrated at MYSELF !!! I keep trying everything all of you are telling me and nothing works. I think because I don't know Excel at all. I think in the replies some of you are assuming I know the basics but I am proving I don't. I once did but not using it I have forgot 99% of what I use to know.

I'm sorry but I think the only way I will be able to make this work is to have the replies be step by step. For example when Fluff said,
"n B2 put =B1-Sum(B4:B5000)
& the same for C2"
I assume that he means to copy the same formula in C2 but change the B to C, Fluff didn't say to change the B to C in column C but I assume that is what he meant.

I hate sounding so dumb but I really need step by step because of my lack of knowledge of Excel.

Sorry everyone

 

[Joe4]

I think your image sheds some light on the issue. You didn't mention previously exactly which cells the starting values are found in. The image shows that.
So, enter these formulas in the following cells:
in D4: =B2+B4
in E4: =C2+C4
in D5: =D4+B5
in E5: =E4+C5

Then copy the formulas in cells D5 and E5 all the way down to the bottom of your data.

 

[e_a_g_l_e_p_i]

I think your image sheds some light on the issue. You didn't mention previously exactly which cells the starting values are found in. The image shows that.
So, enter these formulas in the following cells:
in D4: =B2+B4
in E4: =C2+C4
in D5: =D4+B5
in E5: =E4+C5

Then copy the formulas in cells D5 and E5 all the way down to the bottom of your data.

Sorry but that doesn't work either. I did exactly what you said to do and all it does is when I enter a number in the cell that is my start count and that count should update as I enter numbers below that cell on B&C
I entered 10 in both cells as my starting number, all the cells below that say 10 as well, when I change a number below to add or subtract the top number in my case the red numbers in my image in a previous post should update but all it does is post the same number I entered all the way down to where I copied the formulas ??????????????????????

 

[Joe4]

Sounds like you might have one of two things going on:

1. The AutoCalc feature may be turned off on your spreadsheet. What happens if you press F9? Do your formula values get updated then?

2. You entries are being entered as Text and not Numbers. How do your have columns B and C formatted?
Let say you make an entry into cell B5. Anywhere on your worksheet, enter this formula and see what it returns:
=ISNUMBER(B5)
If it returns FALSE, then your columns are formatted as Text and not Numbers.

 

[e_a_g_l_e_p_i]

Sounds like you might have one of two things going on:

1. The AutoCalc feature may be turned off on your spreadsheet. What happens if you press F9? Do your formula values get updated then?

2. You entries are being entered as Text and not Numbers. How do your have columns B and C formatted?
Let say you make an entry into cell B5. Anywhere on your worksheet, enter this formula and see what it returns:
=ISNUMBER(B5)
If it returns FALSE, then your columns are formatted as Text and not Numbers.

It returns "FALSE" I triple checked to make sure that column is set to number and it is. I still get a "FALSE" ?????

Once again this is what I want to do,
http://www.usedissues.com/images/excel.jpg

The red numbers should update as I subtract numbers below. I would like to be able to add or subtract and have it update the red numbers,however it is difficult to get anything to work for me so I am OK with manually adjusting my total.

 

[Joe4]

We don't need to see the image again. I now know exactly what the problem is. It is a design/data issue. This right here tells me that:

It returns "FALSE" I triple checked to make sure that column is set to number and it is. I still get a "FALSE" ?????

Once a number is entered as Text, changing the format to Number AFTER it has been entered will NOT fix the entries which are already in there (it will only fix future entries). In order to fix existing entries, do the following:

1. Highlight Column B
2. Make sure the entire column is NOT formatted as Text (but as General or Number instead)
3. Go to the Data menu and select "Text to Columns"
4. Click Finish

Repeat the same 4 steps for column C.

Now your formulas should work (and if your tried the ISNUMBER formulas again, it should return TRUE).

 

[e_a_g_l_e_p_i]

We don't need to see the image again. I now know exactly what the problem is. It is a design/data issue. This right here tells me that:

Once a number is entered as Text, changing the format to Number AFTER it has been entered will NOT fix the entries which are already in there (it will only fix future entries). In order to fix existing entries, do the following:

1. Highlight Column B
2. Make sure the entire column is NOT formatted as Text (but as General or Number instead)
3. Go to the Data menu and select "Text to Columns"
4. Click Finish

Repeat the same 4 steps for column C.

Now your formulas should work (and if your tried the ISNUMBER formulas again, it should return TRUE).

Thanks for your help but I give up, I can't keep up with all of you. it is too confusing to me.

 

[Joe4]

Thanks for your help but I give up, I can't keep up with all of you. it is too confusing to me.

How is it confusing?
You asked us to give you very literal step-by-step instructions. That is what I did (steps 1-4).
You don't even really need to understand the explanation, just follow those steps I gave you.

Is there a certain step you don't understand what you are supposed to do?
I'd be glad to explain it to you in more detail.