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

 

[e_a_g_l_e_p_i]

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.

It is confusing because I tried everything all of you suggested and it didn't work. So let me focus on you Joe4

I did the following
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. It doesn't update my numbers in red in the example I put a link to in a previous post. The current total is not updating using the formula that you gave me. I am not saying your formula doesn't work I am saying I can't seem to make it work for me.

It seems in my head to be very simple but I can't get it to work. In the 2 cells I have red numbers I need that to update as I subtract from that beginning number. I would love it to be able to add or subtract so when I get more "apples" or "oranges" the red number in each cell will update.
I am OK with the worksheet just subtracting from my starting number and when I get more I can manually change my starting number.

It is very confusing that it doesn't work. I see you are a Excel MVP so I know your formulas are right I just can't get them to work for me.

Hope that explains why I am confused.

 

[Joe4]

Based on everything you have told me, none of that will work until you follow the steps I lined out in step 18 here.

It appears that we finally found the issue and are in mile 25 of the marathon. Don't quit now! You're almost there!

 

[e_a_g_l_e_p_i]

Based on everything you have told me, none of that will work until you follow the steps I lined out in step 18 here.

It appears that we finally found the issue and are in mile 25 of the marathon. Don't quit now! You're almost there!

I opened a excel worksheet and before doing anything I selected column A and formatted that column to "date" I then selected columns B&C and formatted both columns to "number" You say you don't need to look at my example that I posted a link for in a previous post but my example is using only columns A,B and C so your formula that says
in D5: =D4+B5
in E5: =E4+C5
I don't understand why D&E are even in the formula??

 

[Joe4]

From the very first lines of your original post:

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

 

[e_a_g_l_e_p_i]

From the very first lines of your original post:

Sorry in the confusing I changed the cells being used without realizing it. I only need 3 columns, A,B and C like my link to an example I posted a link to. That example shows only A,B and C being used.

It changed due to the confusion on my part in this thread. I have to go out now and won't be able to reply back if you reply again but I will read it and reply when I get back.

If you want to look at my example the link is here,

http://www.usedissues.com/images/excel.jpg
Once again sorry for the change caused by my confusion, the above link shows what I need. The red numbers should update as I add or subtract in the cells below the red numbers. I will be OK with just subtractions.

Thank you all your help, it isn't working because of me not you.

 

[Joe4]

If all you want is a total of rows 4-22 in row 2, then a basic SUM formula will do that:
in cell B2: =SUM(B4:B22)
in cell C2: =SUM(C4:C22)

However, if you have Text Entries instead of Numeric entries in cells B4:C22, you will still have an issue until that is addressed, as was mentioned in post #18.

 

[e_a_g_l_e_p_i]

If all you want is a total of rows 4-22 in row 2, then a basic SUM formula will do that:
in cell B2: =SUM(B4:B22)
in cell C2: =SUM(C4:C22)

However, if you have Text Entries instead of Numeric entries in cells B4:C22, you will still have an issue until that is addressed, as was mentioned in post #18.

Still not working..... Cells B&C are formatted to "Number"

where do I add the starting amount ??

 

[Joe4]

Do you have an entry in B4?
If so, what does =ISNUMBER(B4) return?

 

[e_a_g_l_e_p_i]

Do you have an entry in B4?
If so, what does =ISNUMBER(B4) return?

Currently I have nothing in any cells, each time it doesn't work I clear the worksheet.

 

[e_a_g_l_e_p_i]

Currently I have nothing in any cells, each time it doesn't work I clear the worksheet.

I put the number 100 in B2 then in another cell I put in the formula ISNUMBER(b2) And I got "true"