How to use built-in Excel functions in PivotTable formula?

Posted to microsoft.public.excel.worksheet.functions

Tim Davies

Posts: n/a

How to use built-in Excel functions in PivotTable formula?

I am trying to use the formula: =MAX('Operating Hours')/Count in a pivotTable
formula, but Excel always returns the sum of the operating hours field and
not the max value. Does Excel have the ability to use the built-in functions
within pivotTables? If so, can someone tell me how to use them?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
feel that the STANDARD DEVIATION formula on Excel is incorrect !!	Ganapati Hegde	Excel Worksheet Functions	3	November 18th 05 04:09 PM
Mathematical explanations/equations for Excel functions in "Help"	mta7000	Excel Worksheet Functions	0	November 4th 05 04:02 AM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
EDIT FORMULA BAR in excel 2003? why not? where is it?	alnav89	Excel Worksheet Functions	2	April 26th 05 07:02 PM
Excel 2003 - Formula result shows as 0:00	Serena	Excel Worksheet Functions	4	November 11th 04 10:18 PM

All times are GMT +1. The time now is 10:40 PM.

Menu

About Us