Posted to microsoft.public.excel.misc

external usenet poster

Posts: 6

Averaging with #N/A Cells

i'm trying to average 5 cells. One has an #n/a value. This causes the
average to say #n/a. Is there a way to correct this?

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
averaging cells	Ravens Fan	Excel Discussion (Misc queries)	9	November 30th 07 05:53 PM
Averaging 14 Cells	Darren	Excel Discussion (Misc queries)	5	June 29th 06 09:52 PM
Averaging Cells Based On Conditions in Neighboring Cells	foofoo	Excel Discussion (Misc queries)	3	June 21st 06 03:10 AM
Averaging Cells	Daniel9684	Excel Discussion (Misc queries)	3	February 17th 06 07:21 PM
Averaging cells which contain #DIV/0!	maryj	Excel Worksheet Functions	4	November 4th 04 01:32 PM

All times are GMT +1. The time now is 07:09 PM.

About Us

"It's about Microsoft Excel"