+ Reply to Thread
Results 1 to 3 of 3

Sum Function Has Changed into Showing Average or Median

  1. #1
    Registered User
    Join Date
    04-06-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Sum Function Has Changed into Showing Average or Median

    Suddenly Excel no longer sums numbers in highlighted cells for us but rather shows averages or medians. Any ideas as to how to return to the original functionality (preferably without reinstalling program)?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Sum Function Has Changed into Showing Average or Median

    I have XL'7, but, try right clicking the average/median and see if you get a pop-up menu of options.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-06-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Smile Re: Sum Function Has Changed into Showing Average or Median

    Quote Originally Posted by protonLeah View Post
    I have XL'7, but, try right clicking the average/median and see if you get a pop-up menu of options.
    Wow, that's great! It did the trick. Thank you so much!

+ 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] Average & Median
    By lstevenson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2014, 02:20 AM
  2. Average and Median by week and month from daily data
    By jjj444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2013, 11:01 PM
  3. Average, Median Max and Min of a Specific Range
    By PraveshG81 in forum Excel General
    Replies: 2
    Last Post: 05-10-2012, 08:14 PM
  4. Median, Average, and Standard Deviation from large set of data
    By Humberto Goyen in forum Excel General
    Replies: 6
    Last Post: 11-30-2005, 08:40 PM
  5. [SOLVED] pivot: average vs. median
    By dave in Toronto in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 10:05 AM

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