Re: Average in Cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

---

• From: britwiz@xxxxxxxxxxx
• Date: 24 Mar 2006 07:14:03 -0800

---

Hi martins

Try this:


=SUM(myRange)/COUNTIF(myRange,"<>0")


Regards


Steve

.

---

• References:
  • Average in Cells
    • From: martins

• Prev by Date: Re: Average in Cells
• Next by Date: Re: changing color of values bigger or smaller than target
• Previous by thread: Re: Average in Cells
• Next by thread: Re: Average in Cells
• Index(es):
  • Date
  • Thread

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint

www.tech-archive.net  > Archive  > Excel  > microsoft.public.excel.newusers  > 2006-03