+ Reply to Thread
Results 1 to 10 of 10

I need formula to sum or total

  1. #1
    Registered User
    Join Date
    03-07-2016
    Location
    America
    MS-Off Ver
    2010
    Posts
    5

    I need formula to sum or total

    Hi,
    May somebody can help me:

    I need to sum or total of F12 and G12 and show results in G12

    Untitled-2.jpg

  2. #2
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    352

    Re: I need formula to sum or total

    hi,

    Welcome in forum..

    u need F12+G12 in G12 it is?
    If answer helped you say Thanks by Add Reputation

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

    Re: I need formula to sum or total

    =F12+G12 in G12 will produce a circular reference
    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.

  4. #4
    Registered User
    Join Date
    03-07-2016
    Location
    America
    MS-Off Ver
    2010
    Posts
    5

    Re: I need formula to sum or total

    Yes I need
    F12+G12 in G12

    F12 will be change

  5. #5
    Registered User
    Join Date
    03-07-2016
    Location
    America
    MS-Off Ver
    2010
    Posts
    5

    Re: I need formula to sum or total

    Hi

    Yes I need
    F12+G12 in G12

    F12 will be change

  6. #6
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    352

    Re: I need formula to sum or total

    Quote Originally Posted by gborislav View Post
    Hi

    Yes I need
    F12+G12 in G12

    F12 will be change
    and what about G12 it will be always same..?

  7. #7
    Registered User
    Join Date
    03-07-2016
    Location
    America
    MS-Off Ver
    2010
    Posts
    5

    Re: I need formula to sum or total

    G12 will be change by adding from F12

    this what i need , as you see there is "Monthly" and "Year to date"

    so if I will add ( change )every month the "Monthly", the "Year to date" should change by by adding "Monthly" + existing already "Year to date" and show new result in cell G12 ("Year to date")

    Thank you

  8. #8
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: I need formula to sum or total

    Right click the sheet tab and select "View Code".
    Paste the below in to the VB Editor.
    Close the VB Editor. Now when you change the value in F12 it will be added to the value already in G12.

    Please Login or Register  to view this content.
    BSB

  9. #9
    Registered User
    Join Date
    03-07-2016
    Location
    America
    MS-Off Ver
    2010
    Posts
    5

    Re: I need formula to sum or total

    Thank you very much, working !!!!

  10. #10
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: I need formula to sum or total

    Happy to help

    BSB

+ 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: 1
    Last Post: 05-13-2015, 12:52 PM
  2. Formula to multiply total number per category with the % of total
    By tantcu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2013, 07:18 PM
  3. formula calculates ratio for Grand Total, not Sub Total for each column
    By vkievsky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2013, 11:26 AM
  4. Replies: 7
    Last Post: 03-28-2013, 09:58 AM
  5. Replies: 3
    Last Post: 03-16-2010, 01:26 PM
  6. Old Lotus Sub Total & Grand Total formula
    By Kylie in forum Excel General
    Replies: 2
    Last Post: 04-09-2006, 07:30 AM
  7. XL formula - total of row = total of column
    By topaz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2005, 06:06 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