Posted to microsoft.public.excel.newusers

Linda $RQ$ $Linda $RQ$ is offline$

external usenet poster

Posts: 6

Average of numbers under 10

Hi,

I am using Excel 2003. On my sheet named "Original" in column K I have a
list of numbers they range from .1 to 50 but could go higher. On another
sheet I have this function =AVERAGE(Original!K2:K10) in a cell which give me
the average of these numbers. I would like to make another cell with the
same function but I want to it to only average items in column K that are
less than 10 and ignore any that are 10 or more.

Thanks,
Linda

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
average a continuous group of numbers and negative numbers are 0	Dumbfounded	Excel Worksheet Functions	3	October 15th 08 11:53 PM
Average highest 16 numbers on a column of 32 numbers	Frank[_10_]	Excel Worksheet Functions	3	May 2nd 08 02:44 AM
average a row of numbers?	wannabe68	New Users to Excel	5	August 7th 07 04:48 PM
average of kth largest numbers in an array of n numbers	georgeb	Excel Worksheet Functions	6	September 5th 05 05:57 AM
Average of numbers in column between to other numbers	Ditandhischeese	Excel Discussion (Misc queries)	2	March 31st 05 03:35 AM

All times are GMT +1. The time now is 12:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us