+ Reply to Thread
Results 1 to 5 of 5

calculate average for all of data field using GETPIVOTDATA?

  1. #1
    andrew
    Guest

    calculate average for all of data field using GETPIVOTDATA?

    am trying to use the GETPIVOTDATA function to calculate the average for all
    of the data field values {=AVERAGE(B10:N44)}. Is is possible to use the
    GETPIVOTDATA in place of hardcoding the range? Thank you.

  2. #2
    Registered User
    Join Date
    05-30-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: calculate average for all of data field using GETPIVOTDATA?

    Hi,

    Have you managed to solve this? I'm having the same problem, and hoping you could help me out if you have found the solution

    thanks.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,247

    Re: calculate average for all of data field using GETPIVOTDATA?

    enrico, 2 things....

    1st, please dont post your own question on some1 elses post, rather, start a new thread
    2nd, that post is over 6 years old and it doesnt look it recieved any suggestions. i doubt the OP is watching it any more
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    05-30-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: calculate average for all of data field using GETPIVOTDATA?

    oh i see.

    Noted. Thanks FDibbins

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,247

    Re: calculate average for all of data field using GETPIVOTDATA?

    no problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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