I need to create a running total based on the color of the text in an adjacent column. I am using 2007 Excel. Essentially, every time I enter a date in "black" text, I need the count to go up by "one"; every time I enter a date in "red" text, I need the count to go down by "one". I need the column titled "Net 15 Rule" to contain the running total, based on the color of the date, as depicted below.
<tbody>
</tbody>
I apologize if I did not format my question properly or use correct terminology, I am rather new to Excel. If you need further information to answer my question, please let me know.
Thanks for any help!!!!!!!!!!
Original Date | Net 15 Rule |
8/29/2012 | 1 |
9/2/2012 | 2 |
9/5/2012 | 1 |
9/9/2012 | 2 |
9/10/2012 | 3 |
9/15/2012 | 4 |
9/18/2012 | 3 |
<tbody>
</tbody>
I apologize if I did not format my question properly or use correct terminology, I am rather new to Excel. If you need further information to answer my question, please let me know.
Thanks for any help!!!!!!!!!!