+ Reply to Thread
Results 1 to 15 of 15

Different Totals For Same Data

Hybrid View

  1. #1
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2508
    Posts
    13,822

    Re: Different Totals For Same Data

    @ NeedForExcel,

    That is very strange! I get the same behavior when rounding all the values! This is simple addition. I am using Office 2013. Are you getting this with all 2007:2016 versions?
    Dave

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Different Totals For Same Data

    Quote Originally Posted by FlameRetired View Post
    @ NeedForExcel,

    That is very strange! I get the same behavior when rounding all the values! This is simple addition. I am using Office 2013. Are you getting this with all 2007:2016 versions?
    Hi @FlameRetired,

    Thank you for taking out time to look into the problem..

    Currently, I have tried it on 2013 & 2016 and it does have the same issue on both versions.. Don't have 2007 & 2010 anymore. Sorry, I haven't updated that in my profile..
    Cheers!
    Deep Dave

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Different Totals For Same Data

    Quote Originally Posted by NeedForExcel View Post
    Currently, I have tried it on 2013 & 2016 and it does have the same issue on both versions.. Don't have 2007 & 2010 anymore. Sorry, I haven't updated that in my profile..
    the same issue is in Ex97 and 2016 64-bit (don't know about Ex5.0)

+ 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. Pivot Table Percentage of grand totals listed under the grant totals
    By Biker102 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-31-2017, 01:31 PM
  2. [SOLVED] Cell Refrencing multiple sheet totals to a totals page
    By 007Buff in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-08-2015, 02:23 PM
  3. [SOLVED] How to get cumulative totals from weekly totals (IE sum of all previous cells)?
    By moeburn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2013, 07:29 PM
  4. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  5. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  6. Method for calculating Invoice Totals and Grand totals
    By sahran4441 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2010, 10:24 PM
  7. Replies: 4
    Last Post: 01-10-2008, 12:31 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