Posted to microsoft.public.excel.misc

avg w/ missing #s avg w/ missing #s is offline

external usenet poster

Posts: 1

I need help calculating averages with missing values?

I have tried what they tell me on the help page
=AVERAGE (IF(A2:A7,.0. A2:A7, ""))

but it does not work- I really need to figure it out-- any help would be
really appreciated!

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
Populate Missing Values	pamarty	Excel Worksheet Functions	1	June 20th 06 08:09 PM
Calculating Dates Using Different Values for NETWORKDAYS	Kelly	Excel Worksheet Functions	9	April 22nd 06 03:10 PM
Calculating weighted averages	rgl	Excel Discussion (Misc queries)	6	February 22nd 06 06:15 PM
Excel Charts - Missing Values	ediamond	Charts and Charting in Excel	2	January 18th 06 07:56 PM
Missing values in Excel Line Chart	mw55309	Charts and Charting in Excel	1	January 19th 05 12:10 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us