Search : in
By :

Cell count

Last answer on Jun 15, 2009 2:08:00 am BST hockey_pro, on Jun 13, 2009 8:51:41 pm BST 
 Report this message to moderators

Hello,
i am trying to use microsoift office excel and trying to count in a count cell.. like adding numbers together that i add into that certain cell as per example: i have 5 in cell b1 i reenter in b1 2 push enter and it will show now 7 (5+2) if someone can help me please

Configuration: Windows Vista Internet Explorer 7.0

Best answers for « cell count » in :
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
How to count number of words in MS Words sheet! ShowHow to count number of words in MS Words sheet! It is quite simple to count the number of words in a Microsoft word sheet. This tip might be very useful for example, if you wish to make a presentation on Microsoft word for an approximate number...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

 venkat1926, on Jun 15, 2009 2:08:00 am BST

I do not know whether you can enter number in a cell to add to the previous entry. you can do one trick
suppose b1=5
riight click sheet tab and click view code and copy paste this code 

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
On Error GoTo line1
If Target.Address <> "a1" Then
Range("b1") = Target + Range("b1")
End If
line1:
Application.EnableEvents = True
End Sub


now enter any number to A1 and see what happens to B1
again enter another no. in A1 and see what happens B1
post feedback

   
Reply to venkat1926
Ask your question Reply
They need your help