Posted to microsoft.public.excel.misc

help

external usenet poster

Posts: 67

Averages

Help. I've calculated the average of three different cells in three different
rows that are not in sequential rows. The problem is that some of the cells
may contain a zero so the formula should only divide by two instead of three.
Anyone of the cells could be zero so you may have to divide by one, two or
three. Is there a formula???

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Averages	Steve Moss	Excel Discussion (Misc queries)	2	December 9th 08 09:59 AM
Averages	Marvin	Excel Discussion (Misc queries)	5	July 4th 08 09:34 AM
Help with Averages	TimJames	Excel Worksheet Functions	2	March 6th 08 08:53 PM
first ten and last ten averages	aazharr	Excel Worksheet Functions	2	February 28th 08 03:28 PM
30, 60 or 90 day averages	Bendleton	Excel Worksheet Functions	3	December 22nd 06 08:34 AM

All times are GMT +1. The time now is 06:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us