+ Reply to Thread
Results 1 to 7 of 7

How to sum A1 cell value with B1 cell's Existing value and show results in B1

  1. #1
    Registered User
    Join Date
    07-25-2010
    Location
    Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    7

    How to sum A1 cell value with B1 cell's Existing value and show results in B1

    How can i sum a cell value with an existing cell's value and show results in same cell. Example: My A1 cell value is 2 and my B1 value is 3 which is already exists in A1 and B1 cell. i want to sum A1 with B1 and show results in B1 Cell. And it will be 5 in B1 Cell. When i run the vba again it will be 7 in B1. Every time sum B1 cell value with A1 and show results in B1 cell. How can i do this?

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: How to sum A1 cell value with B1 cell's Existing value and show results in B1

    Something like this:

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: How to sum A1 cell value with B1 cell's Existing value and show results in B1

    This?
    Please Login or Register  to view this content.
    Edit kokosek was faster.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    07-25-2010
    Location
    Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: How to sum A1 cell value with B1 cell's Existing value and show results in B1

    Dear KOKOSEK and dotchiejack thanks for reply your solution is working fine. Can i sum sheet1 sheet's A1 cell value with sheet2 sheet's cell value?

  5. #5
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: How to sum A1 cell value with B1 cell's Existing value and show results in B1

    Yes no problem.
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    07-25-2010
    Location
    Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: How to sum A1 cell value with B1 cell's Existing value and show results in B1

    Quote Originally Posted by dotchiejack View Post
    Yes no problem.
    Please Login or Register  to view this content.
    Many many Thanks bro. Its working. Problem solved.

  7. #7
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: How to sum A1 cell value with B1 cell's Existing value and show results in B1

    Glad to help

+ 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. [SOLVED] Need to show results from either 1st OR 2nd cell
    By b00 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-09-2014, 07:48 PM
  2. Keep the formula, show results in new cell
    By HerrMetik in forum Excel General
    Replies: 7
    Last Post: 03-24-2011, 12:06 PM
  3. Show look up results in user form and display warning if overwritting existing entry
    By yapjooleong in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2010, 01:50 PM
  4. Some formula results will not show up in the cell
    By Space Elf in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  5. [SOLVED] Some formula results will not show up in the cell
    By Biff in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] Some formula results will not show up in the cell
    By Space Elf in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Some formula results will not show up in the cell
    By Space Elf in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] Some formula results will not show up in the cell
    By Space Elf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2005, 09:05 PM

Tags for this Thread

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