+ Reply to Thread
Results 1 to 4 of 4

How to show up or display the details numbers inside the sum formula&keep value as sum

  1. #1
    Registered User
    Join Date
    04-23-2021
    Location
    Paris
    MS-Off Ver
    365
    Posts
    5

    Post How to show up or display the details numbers inside the sum formula&keep value as sum

    Dear All,
    i need help on this tricky situation i have in order to fill statements properly and keep track of everything numbers we are dealing with.

    i have to display the addition of numbers in the sum formula i made and keep the value as sum but writing and reading the addition.
    For instance cell A1 (=1), A2(=2) and then A3(=weither sum(A1:A2) or =A1+A2 and me i want to read =1+2 but keeping the sum which is 3
    is there a way to do it in excel without developping vba or some codes?

    how should i proceed to have this complete thus will allow me to display the addition in the right cells i want but still allow scoring system to calculate the rating.
    Thank you so much for your help,

    if you have any clue.

    Rgds,
    Fred

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: How to show up or display the details numbers inside the sum formula&keep value as sum

    Am i understanding you correctly. Using your example you provided:
    In cell A3, instead of the formula bar showing =A1+A2, you want the formula to show =1+2 while still acting as the original formula?
    If this is TRUE, then the only possible way i can think of would be VBA.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Registered User
    Join Date
    04-23-2021
    Location
    Paris
    MS-Off Ver
    365
    Posts
    5

    Re: How to show up or display the details numbers inside the sum formula&keep value as sum

    Hello, thank you
    so what will be the appropriate code please?
    thanks cause i don't know anything about coding with vba
    regards,

    Fred

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: How to show up or display the details numbers inside the sum formula&keep value as sum

    I feel that you will need to ask a moderator to move this thread to the VBA forum to get more specific help.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 2
    Last Post: 02-22-2018, 03:55 AM
  2. Need a formula to bring display previous row details in POWERPIVOT
    By siddharth_s1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-19-2015, 11:32 AM
  3. How to get a number show up as 0 inside a formula.
    By mlbdc2012 in forum Excel General
    Replies: 11
    Last Post: 02-10-2015, 09:50 AM
  4. Replies: 12
    Last Post: 11-02-2014, 12:55 PM
  5. Replies: 14
    Last Post: 01-23-2012, 08:37 AM
  6. Formula to show only valid cell details
    By mal.b.graham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2011, 09:05 AM
  7. Replies: 2
    Last Post: 03-12-2006, 07:20 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