Thread: I need help calculating averages with missing values?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
avg w/ missing #s avg w/ missing #s is offline
external usenet poster
  
Posts: 1
Default I need help calculating averages with missing values?
I have tried what they tell me on the help page
=AVERAGE (IF(A2:A7,.0. A2:A7, ""))

but it does not work- I really need to figure it out-- any help would be
really appreciated!
Reply With QuoteReply With Quote