Thread: YTD average - How do I create a formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana
 
Posts: n/a
Default YTD average - How do I create a formula?
A column of monthly totals
Jan 400
Feb 800
Mar 0
Apr 0
May 0
Need a simple formula that will return an average on non zero months ie: 600
Reply With QuoteReply With Quote