+ Reply to Thread
Results 1 to 4 of 4

Pivot table average gives divide by zero error

  1. #1
    Registered User
    Join Date
    07-05-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    9

    Pivot table average gives divide by zero error

    So I have a pivot table:
    http://ubuntuone.com/4NJT6l3iRGK077I2kX74yf

    I have grouped the monthly dates into quarters and years in the pivot table, and I want to use the pivot table to find the average rate during each quarter of every year. But when I choose average I get the divide by zero error in the pivot table as you can see in the above table.

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    483

    Re: Pivot table average gives divide by zero error

    Simple, format it as number>> remove the average from the pivot and add again. You will get the desired result
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,678

    Re: Pivot table average gives divide by zero error

    If need be please post sheets on the forum. External links are potentially dangerous and/or blocked by local admin

  4. #4
    Registered User
    Join Date
    07-05-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Pivot table average gives divide by zero error

    So I deleted the pivot table, formatted those cells as a number, and then remade the pivot table, it still gives the divide by zero error. I also tried changing form the average to the count, and then back to the average, didn't work. Sorry I must be doing something wrong. I'm still quite a beginner with excel
    Attached Files Attached Files

+ 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, Divide by count of months?
    By DoriBeE in forum Excel General
    Replies: 2
    Last Post: 05-10-2011, 04:20 PM
  2. How do you divide two cells in a pivot table to equal a %?
    By Annette in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-25-2006, 03:50 PM
  3. Pivot Table - divide two results
    By Pete Petersen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2005, 02:06 PM
  4. [SOLVED] Pivot Table Divide By Zero
    By Thomas Moufet in forum Excel General
    Replies: 5
    Last Post: 01-15-2005, 02:06 PM
  5. Hide Pivot Table Divide by 0 error
    By Todd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2005, 06:06 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