Thread: Average IF Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SandiVaughn SandiVaughn is offline
external usenet poster
  
Posts: 1
Default Average IF Function
How can you test a range of cells to be greater than or less than another
cell using the average if function?

Ex: =AVERAGEIFS(A1:A4,A1:A4,"A6",A1:A4,"A7")

Keep getting the #DIV/0! error!

HELP!!!!! Thank you!
Reply With QuoteReply With Quote