Thread: average from multiple worksheet using if is number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arjen van... arjen van... is offline
external usenet poster
  
Posts: 32
Default average from multiple worksheet using if is number
If you're using Excel 2007 you can use the AVERAGEIF function.

=AVERAGEIF(J2:J46,"<#N/A")

In this method the count that the average is based on will not include the
N/A cells. Should they be?
Reply With QuoteReply With Quote