Thread: Formula for average with a "IF" statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
  
Posts: 347
Default Formula for average with a "IF" statement
Hi,

=AVERAGE(IF(A1:A100<0,A1:A100))
enter using Ctrl+Shift+Enter

Cheers!
Jean-Guy

"latripl" wrote:

I am trying to do a formula for averaging a series of numbers (which I can
do) exept if there is zero in the series I want to ignore it in the avg. How
do I write an IF statement for this?

Reply With QuoteReply With Quote