ExcelBanter - calculate average for all of data field using GETPIVOTDATA?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - calculate average for all of data field using GETPIVOTDATA? (https://www.excelbanter.com/excel-worksheet-functions/73117-calculate-average-all-data-field-using-getpivotdata.html)

andrew

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.

All times are GMT +1. The time now is 02:51 PM.