Posted to microsoft.public.excel.misc

KhaVu

Posts: n/a

AVERAGE function returns #DIV/0! error

I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
calculation.

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
Conditional average function	Andres	Excel Worksheet Functions	1	August 9th 05 06:31 PM
Auto average function	Diederik	Excel Worksheet Functions	3	June 14th 05 03:56 PM
weeknum function returns name error	Unison Mike	Excel Worksheet Functions	4	May 24th 05 09:27 PM
average function in Excel 2002	Sherry	New Users to Excel	13	May 8th 05 01:49 PM
# DIV/0! error in Excel	Helpwanted	Excel Discussion (Misc queries)	8	May 6th 05 09:31 PM

All times are GMT +1. The time now is 01:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us