Need Excel to add next value of data sequence to cumulative total of all prior data values.?

Question

Need to enter a string of up to 1000 data values in cell C1 about 10 seconds apart. Each new entry overwrites/replaces previous entry. Would like another cell, say D1, to record cummulative or running total of all data entries.

Answer 1

As far as I know, I don't know of any function that will do things like that. I think you'd need to do some VB programming that can be run in excel that could do what you want.

Answer 2

Below is a VBA module that will do what you want.

First name cell C1 "Data" and name cell D1 "CumTotal" Do not put any formula in cell D1.

Now press Alt-F11 to bring up the Visual Basic window. In the Project-VBA Project window, double-click on the sheet name for your worksheet (not the name of the workbook, the name of the sheet). Then copy and paste the code below.

The first line of the pasted code will be red. Change "ByVa..." to "ByVal" and it should change to black.

Whenever C1 changes, the macro is automatically executed. It adds the value in C1 to the previous value in D1 and sets D1 to the new total.

Since you have named the cells, you can use cells other than C1 and D1 for the input values and cumulative total.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Dim DataCell As Range
Set DataCell = Range("Data")
If Target = DataCell Then
Range("CumTotal").Value = Range("CumTotal").Value + Range("Data").Value
End If

End Sub

You can email me through Yahoo!Answers if you have any questions.

Answer 3

Since your data is all in C1 and is being overwritten writing a formula is out since the data does not exist. Is there a reason all data is in C1 vs c1, c2, c3, ...so a formula can easily be written? There are lots of cool formulas for number strings however more info is needed

Answer 4

I am not sure that I understand your question but if it is if you need Excell I would say no. There is a free Office program that works much like Micro Soft Office. It is called Open Office and it is free. I found it on the Kim Komando website. It is a very good program and does not carry any virus or spyware.