Running count in one cell

[Snarg]

Hello,

Allow me to apologize in advance for what may seem to some to be a rather ridiculous question. I have tried searching Google and this forum with no luck. One drawback to the Internet is that sometimes there is TO MUCH information I have found many subjects that have the same topic title as me, but they do not describe or do what I am looking for. Allow me to explain:

I have one sheet in my workbook. In it I am using two columns. Column A is 'Name'. Column B is 'Number'. I have frozen the top row. In cell 1A I have put 'Total ='. In cell 1B I would like to have a running total taken from values entered into Column B.

Example (I don't know why there is a HUGE amount of space after this line. Sorry about that):
<table>
<tbody>
<tr height="20">
<td height="20" style="height:20px;width:156px;">
Total =</td>
<td style="width:64px;">
 </td>
</tr>
<tr height="20">
<td height="20" style="height:20px;">
Red</td>
<td align="right">
16</td>
</tr>
<tr height="20">
<td height="20" style="height:20px;">
Blue</td>
<td align="right">
15</td>
</tr>
<tr height="20">
<td height="20" style="height:20px;">
Orange</td>
<td align="right">
9</td>
</tr>
<tr height="20">
<td height="20" style="height:20px;">
Pink</td>
<td align="right">
31</td>
</tr>
<tr height="20">
<td height="20" style="height:20px;">
Yellow</td>
<td align="right">
16</td>
</tr>
</tbody>
</table>

'Total =' should be updated as I enter a value.

I hope that I have been able to explain what I am looking for as best as possible. If you have any questions please feel free to ask. Thank you for any responses.

 

[Rick Rothstein]

I have one sheet in my workbook. In it I am using two columns. Column A is 'Name'. Column B is 'Number'. I have frozen the top row. In cell 1A I have put 'Total ='. In cell 1B I would like to have a running total taken from values entered into Column B.

Total =
Red	16
Blue	15
Orange	9
Pink	31
Yellow	16

<colgroup><col width="68" style="width: 51pt;" span="2"> <tbody> </tbody>

'Total =' should be updated as I enter a value.

Assuming your numbers start in cell B2, put this formula in B1...

=SUM(B2:B5)

where the 5 in B5 should be the row number of the last cell with (or that you ever expect to) have a value in.

 

[bbott]

Can you just use SUM in B1 and adjust for your range?

=SUM(B2:B10000)

 

[Snarg]

Thank you Rick and bbott for your replies.

I know of the 'SUM' function, and I know how to get it to create a total after all of the values have been input. But, what I would like to have happen is to have cell B1 display the total as I enter the values into Column B. If this is at all possible please, let me know.

Thank you for your time.

 

[Rick Rothstein]

Thank you Rick and bbott for your replies.

I know of the 'SUM' function, and I know how to get it to create a total after all of the values have been input. But, what I would like to have happen is to have cell B1 display the total as I enter the values into Column B. If this is at all possible please, let me know.

That is what will happen UNLESS you have automatic calculations turned off for some reason. Check the setting for it in Excel Options/Formulas/Calculation options.

 

[Snarg]

That is what will happen UNLESS you have automatic calculations turned off for some reason. Check the setting for it in Excel Options/Formulas/Calculation options.

It's always something simple, isn't it?

Thanks Rick and bbott. I made the mistake of assuming I knew more than you did and did not bother to try the formulas. It have put it as so: =SUM(B2:B1000)

Seems to work a treat. Thank you for your time.