Re: $$Excel-Macros$$ Help Req: average

2010-10-07 Thread Srinivasan Ethirajalu
=sum(*Your_range*)/(COUNT(*Your_range*)-COUNTIF(*Your_range*,0)) On Thu, Oct 7, 2010 at 8:02 PM, Dilip Pandey wrote: > Dear Mr. Rao, > > Please find the solved spreadsheet attached with this email. I have used > SumProduct and Count functions to solve the query. Let me know if this > helps :)

Re: $$Excel-Macros$$ Help Req: average

2010-10-07 Thread Dilip Pandey
Dear Mr. Rao, Please find the solved spreadsheet attached with this email. I have used SumProduct and Count functions to solve the query. Let me know if this helps :) Best Regards, DILIPandey On Fri, Oct 1, 2010 at 12:08 AM, NRao Mynampati wrote: > Hi experts, > how to eleminate zeros while