Thread: Subtotal Avg Exclude "0" Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
  
Posts: 590
Default Subtotal Avg Exclude "0" Values
Excel2003 ...

In Row 1 I have Subtotal "Avg" Function ... =subtotal(1,myrange)

Issue ... I wish to exclude "0" values from the calculation.

How do I write to do this? ... Thanks ... Kha


Reply With QuoteReply With Quote