Thread: average-if-and formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Knox Knox is offline
external usenet poster
  
Posts: 45
Default average-if-and formula
{=AVERAGE(IF(AND(B2:B13241=1,D2:D13241=2),N2:N1324 1,""))}

why doesn't this formula work? thanx!
Reply With QuoteReply With Quote