Need help with formulas in Excel

Microsoft Excel 2003 (full product)
February 23, 2011 at 05:39:41
Specs: Windows XP
I am trying to find a way to enter multiple numbers into a single cell and just show the total.

Day#1- A1 enter 5 and save the spread sheet
Day#2-A1 enter 12 and save the Spread sheet.

I am tracking various times on equipment, currentley I show the time for each day by saving the file per day. The total for the day is totaled in a seperate column, the issue is every day I have to physicaly do the math when entering into the same cell. Can this be done in an easier way?

See More: Need help with formulas in Excel

Report •

February 23, 2011 at 09:22:01
You can't enter an number and a formula in the same cell, so it can't be done within Excel itself.

You would need VBA...maybe something like this...

Whatever number you enter in A1 will be added to B1

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "$A$1" Then
   Range("B1") = Range("B1") + Target
  End If
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question