=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 :)
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
Hi experts,
how to eleminate zeros while selective range for average
function.Please find the attachement here fro your reference.
Regards,
Rao
--
--
Some important links for excel users:
1. Follow us on TWITTER for
