| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Instead Of A Pivot Table
Thanks!
That got it! "Vito" wrote: Sorry about that. Don't know what I was thinking :( Try: =AVERAGE(IF((A2:A11="A")*(B2:B11="Agent"),C2:C11)) confirmed with CTRL+SHIFT+Enter -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=489187 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| pivot table : formula to absolute reference a subtotal | Excel Discussion (Misc queries) | |||
| PIVOT TABLE FORMULA | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
Threaded Mode
