| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Average in Pivot Table
I have created a formula in a Pivot Table to average A,B and C.
I have tried the following with the same results: =AVERAGE(A,B,C) =Sum(A,B,C)/Count(A,B,C) A B C Should be Formula 1 0.75 1 0.9167 91.67% (blank) 0.75 1 0.875 58.33% 1 0.5 1 0.8333 83.33% 1 0.5 0 0.5 50.00% 1 1 1 1 100.00% (blank) 1 1 1 66.67% 1 1 1 1 100.00% Any other suggestions? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Average Question | Excel Worksheet Functions | |||
| Average in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot table average | Excel Discussion (Misc queries) | |||
| How do I use a pivot table to get an average count? | Excel Discussion (Misc queries) | |||
| How to Get Sum of the Average in Pivot Table? | Excel Discussion (Misc queries) | |||
Threaded Mode
