Posted to microsoft.public.excel.worksheet.functions

Graham

external usenet poster

Posts: 155

Calculating Average

I am trying to calculate teh average of a column without counting blanks. How
can I do this? My current formula is =AVERAGE(X8:X26) but is counting blanks
in it. In that column, I have formulas to enter in the number needed...is
this a problem? Thanks for your help. Graham

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
Calculating the average	Andy_Trow	Excel Discussion (Misc queries)	3	July 27th 07 02:15 PM
Calculating moving average	[email protected]	Excel Discussion (Misc queries)	1	April 4th 07 09:52 AM
Calculating moving average	[email protected]	Excel Worksheet Functions	1	April 4th 07 09:52 AM
Function Key for Calculating Average?	robin	Excel Worksheet Functions	17	November 2nd 06 11:47 PM
calculating moving average	odey1234	Excel Worksheet Functions	2	March 29th 05 02:06 PM

All times are GMT +1. The time now is 05:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us