+ Reply to Thread
Results 1 to 5 of 5

Sum all the entries of same Cell

  1. 05-10-2017, 04:13 AM #1
    farazaw
    farazaw is offline
    Registered User
    Join Date
    05-10-2017
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    1

    Sum all the entries of same Cell

    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.
    Reply With QuoteRegister To Reply
  2. 05-10-2017, 04:34 AM #2
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Sum all the entries of same Cell

    Use a formula in B1
    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    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: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by Sintek; 05-10-2017 at 04:45 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 05-10-2017, 04:47 AM #3
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Sum all the entries of same Cell

    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.
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
  4. 05-10-2017, 04:48 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Sum all the entries of same Cell

    To a worksheet code module
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-10-2017, 04:56 AM #5
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Sum all the entries of same Cell

    Try this

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bold latest entry in cell and unbold remaining entries in the same cell
    By Parker4001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2016, 08:54 PM
  2. if cell contains any of the entries in a column, insert specific text in neighboring cell
    By robbyvegas in forum Excel General
    Replies: 8
    Last Post: 10-28-2015, 10:22 AM
  3. Removing entries using Selection.Autofilter, but keeping the greatest 100 entries?
    By artenry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2014, 03:51 PM
  4. [SOLVED] Need to expand an a cell formula based on the entry of several other cell entries
    By mikerules in forum Excel General
    Replies: 5
    Last Post: 07-06-2014, 11:41 PM
  5. highlight cell if no entries or more than one entries are made
    By Elainefish in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-14-2013, 02:30 PM
  6. Moving column entries to row entries (and vice versa) automatically instead of manually?
    By kds8 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2013, 03:38 PM
  7. [SOLVED] Read entries-locate entries and print entries
    By akotronis in forum Excel General
    Replies: 4
    Last Post: 05-01-2012, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1