ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Calculations (https://www.excelbanter.com/excel-discussion-misc-queries/241449-pivot-table-calculations.html)

Soccerboy83

Pivot Table Calculations
 
I am currently trying to create formulas in my pivot table to help calculate
a certain field. I am dealing with temperatures and would like to analyze
the calculated data more easily. i currently have a list of Maximum
Temperatures and Minimum Temperatures. When i create the Pivot Table i can
use some of the preconceived formulas such as AVERAGE, SUM, COUNT, etc. but
know i want to take The Average Maximum Value and the Average Minimum Value,
add them together, and divide by two. Basically i know what to find the
Average of the Averages. Can someone please point me in the right direction.


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com