+ Reply to Thread
Results 1 to 10 of 10

Overall total is not displaying

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Overall total is not displaying

    Overall total is not displaying
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Overall total is not displaying

    You have 6 sheets there, and you have notr even told us which sheet the problem is in. Sorry, but I am not a mind reader... Can we have some more information?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Overall total is not displaying

    DKF-GloBUD

  4. #4
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Overall total is not displaying

    DKF and DKF--GloBUD

  5. #5
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Overall total is not displaying

    please help me quickly

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

    Re: Overall total is not displaying

    It appears that in both cases the problem is with a circular reference.
    On the DKF-GloBUD sheet change F76 from =SUM(F71:F84) to =SUM(F71:F75)
    On the DKF sheet change F75 from =SUM(F70:F83) to =SUM(F70:F74)
    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.

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Overall total is not displaying

    The problem is in F76. Fix it and all is OK. Also, please DO NOT be so impatient. We are not your employees. We do this for fun. Comments like "please help me quickly" when you have done little or nothing to explain your problem does not impress anyone.

  8. #8
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Overall total is not displaying

    thanks alot

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

    Re: Overall total is not displaying

    You're Welcome. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

  10. #10
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Overall total is not displaying

    close this thread

+ 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. Please Help......Formula For Displaying Total Overdue - Excels
    By APRILIA NELA in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2016, 10:24 PM
  2. [SOLVED] Count the number of times a value appears across multiple sheets displaying a total
    By Philbe in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2014, 11:31 PM
  3. Excel 2007 : Formula for displaying Total Overdue entries.
    By noahsampeer in forum Excel General
    Replies: 4
    Last Post: 12-16-2010, 01:05 PM
  4. Problem in displaying total amount in report
    By Nancy123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2010, 12:06 PM
  5. Linking two spreadsheets using date while displaying the added total number of months
    By supraman3001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2009, 11:10 AM
  6. displaying ongoing total in a fixed cell
    By office boy in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 09-28-2007, 04:06 PM
  7. Running Total in Pivot Chart Not Displaying Individual Value
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2006, 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1