+ Reply to Thread
Results 1 to 9 of 9

Adding Numbers To a Cell that Already Has Numbers

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2013
    Posts
    14

    Adding Numbers To a Cell that Already Has Numbers

    Let's say I'm keeping track of commission that was paid throughout the month to Bob and John. As a commission comes in, I list whether it was Bob or John down Column A, and then the amount next to it in Column B. Is there a simple code that I can use that sums on an ongoing basis the total's for both Bob and John? In reality, I'm tracking commissions over 20 different insurance companies and 6 different producers, so I'm hoping that I can scale the answer up.

    A1 = John B1 = $50
    A2 = Bob B2 = $75
    A3 = John B3 = $60
    A4 = Bob B4 = $100
    A5 = John B5 = $500
    A6 = John B6 = $25


    C1 = John's Total
    C2 = Bob's Total

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: Adding Numbers To a Cell that Already Has Numbers

    You can use SUMIF for the simple case described, or SUMIFS for multiple conditions. Or you could select your data and insert a Pivot Table.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Adding Numbers To a Cell that Already Has Numbers

    Hi,

    Have you tried a regular SUMIF formula. e.g.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    ditto for Bob of course.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Adding Numbers To a Cell that Already Has Numbers

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    v A B C D E
    1 John $50 John 635
    2 Bob $75 Bob 175
    3 John $60
    4 Bob $100
    5 John $500
    6 John $25
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: Adding Numbers To a Cell that Already Has Numbers

    @Richard: "B:B" ... ?

  6. #6
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Adding Numbers To a Cell that Already Has Numbers

    B:B refers to every cell in column B, from B1 to whatever the maximum number of rows are.
    It's not efficient to do it that way, but as you didn't supply a specific data range then that's as good an answer as any.
    Obivously if you'd have said I've got 1000 rows of data beginning at row 1 then the solution would have involved B1:B1000
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  7. #7
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: Adding Numbers To a Cell that Already Has Numbers

    The question was to Richard because he had put B:B in quotes. I understand the relevance of B:B. Please notice that I did not start the thread; not my question.

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Adding Numbers To a Cell that Already Has Numbers

    Quote Originally Posted by InvisibleMan View Post
    @Richard: "B:B" ... ?
    ...sorry, I was in VBA mode

    It should of course have been simply B:B

  9. #9
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: Adding Numbers To a Cell that Already Has Numbers

    I know. Just drawing it to your attention.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-11-2015, 11:01 AM
  2. Mirror a cell while adding to numbers
    By Yembo77 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-19-2014, 06:21 PM
  3. [SOLVED] Adding numbers in the same cell
    By JimLau in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-27-2012, 11:10 PM
  4. Replies: 1
    Last Post: 06-12-2012, 05:28 AM
  5. Adding cell reference numbers together
    By mickeymorris626 in forum Excel General
    Replies: 5
    Last Post: 05-05-2011, 01:06 PM
  6. Adding up numbers that are in one cell
    By Shoubakka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2011, 04:51 AM
  7. Replies: 4
    Last Post: 11-16-2008, 05:48 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1