Sum all the entries of same Cell

**farazaw** · 05-10-2017, 04:13 AM

Hi,
I have numbers in cell A1 which I change based on my sales.
I need to get the sum of all the entries in A1 to be shown in B1.
Please help.

**Sintek** · 05-10-2017, 04:34 AM

Use a formula in B1

Formula:

=SumNums(A1)

EDITED:The above goes hand in hand with code
https://www.extendoffice.com/documen...ngle-cell.html

Below is just a formula that should work

Formula:

=SUMPRODUCT(MID(a1,ROW(OFFSET($A$1,,,LEN(a1))),1)+0)

**ImranBhatti** · 05-10-2017, 04:47 AM

what I understood is that user want to enter i.e,200 in A1 and B1 should show 200
then if he changes the value of A1 from 200 to say 300 , now the b1 should display 500 hunderd.

**ImranBhatti** · 05-10-2017, 04:56 AM

Try this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target = Range("A1") Then
Range("B1").Formula = "=" & Range("A1").Value + Range("B1").Value
End If
End Sub

**jindon** · 05-10-2017, 04:48 AM

To a worksheet code module

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address(0, 0) <> "A1" Then Exit Sub
    Application.EnableEvents = False
    [b1] = [sum(a1:b1)]
    Application.EnableEvents = True
End Sub

Sum all the entries of same Cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Sum all the entries of same Cell

Re: Sum all the entries of same Cell

Re: Sum all the entries of same Cell

Re: Sum all the entries of same Cell

Re: Sum all the entries of same Cell

Thread Information

Users Browsing this Thread

Similar Threads

Bold latest entry in cell and unbold remaining entries in the same cell

if cell contains any of the entries in a column, insert specific text in neighboring cell

Removing entries using Selection.Autofilter, but keeping the greatest 100 entries?

[SOLVED] Need to expand an a cell formula based on the entry of several other cell entries

highlight cell if no entries or more than one entries are made

Moving column entries to row entries (and vice versa) automatically instead of manually?

[SOLVED] Read entries-locate entries and print entries

Bookmarks

Bookmarks

Posting Permissions