Closed Thread
Results 1 to 2 of 2

replacing a pivot that counts months and averages totals

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    179

    replacing a pivot that counts months and averages totals

    the attached excel file shows in detail the formulas and results I want to replace what the pivot is doing.

    In short, the pivot is a simple count of 12 months, then the results returns only the months that have values (looking to replace this with formula in data tab)

    then, based on the results of the count, we are averaging the results if they are greater that 2. I want a formula that will be constantly changed. For instance, tf the count results are greater that 6, average these selected months totals.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,103

    Re: replacing a pivot that counts months and averages totals

    There was no need to open a new thread. Go back to your original thread and post the file there, please.

    https://www.excelforum.com/excel-for...id-months.html

    Duplicate thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 03-28-2018, 01:07 PM
  2. Replies: 0
    Last Post: 09-18-2013, 10:04 PM
  3. To display only grand totals by months in the pivot table
    By Excel Dumbo in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-03-2013, 09:56 PM
  4. Counts and Averages
    By alyssa6363 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-22-2013, 08:47 AM
  5. Averages and counts on volumes
    By sajeel in forum Excel General
    Replies: 9
    Last Post: 07-15-2009, 02:17 PM
  6. Macro that counts rows and averages data in row
    By KnightRiderAW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2005, 12:15 PM
  7. Averages and Counts from different columns
    By sonofroy in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 05-06-2005, 04:06 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