Results 1 to 2 of 2

replacing a pivot that counts months and averages totals

Threaded View

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

    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.

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. [SOLVED] 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