Thread: How do I get an average sale if multiple columns?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd Todd is offline
external usenet poster
  
Posts: 177
Default How do I get an average sale if multiple columns?
Column I J N
11 DP 3100
21 AF 10000
41 AF 8000
21 DP 12000
How do I get the average sale if column N=sale amount if I=11 and J=DP or if
I=21 J=AF Average Sale=? Please help me.
Thanks
Todd
Reply With QuoteReply With Quote