Posted to microsoft.public.excel.worksheet.functions

John Mac

external usenet poster

Posts: 13

Averaging data with errors

I am trying to take the average of some data but some of the cells contain
errors (as there is data missing for the function to calculate). In my
database there will always be some missing data so these errors will be
present. Is there any way of taking an average of data that contains errors?
eg. average(a1,a2,a3) equals 4 whe
a1=5
a2=#N/A
a3=3
Many thanks for your help
John

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
Averaging data and rounding up	John Mac	Excel Worksheet Functions	3	July 25th 07 02:58 AM
averaging data	James	Excel Discussion (Misc queries)	10	December 11th 06 03:12 AM
averaging particular blocks of data	robert111	Excel Discussion (Misc queries)	6	July 12th 06 02:41 PM
Averaging data	Capt Bill	Excel Worksheet Functions	2	March 27th 06 10:13 AM
incremental averaging of data	ndflyguy	Excel Discussion (Misc queries)	1	October 27th 05 04:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us