View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vito
 
Posts: n/a
Default Formula Instead Of A Pivot Table


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