| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use a function to average all the numbers except 8 in a
Thank you so much! Valko.
-- happy world "T. Valko" wrote: Try one of these: =SUMIF(A1:A10,"<8")/(COUNT(A1:A10)-COUNTIF(A1:A10,8)) Or, this array** formula: =AVERAGE(IF(A1:A10<8,A1:A10)) **entered with the key combination of CTRL,SHIFT,ENTER (not just ENTER). Biff "dreamer" wrote in message ... how to use a function to average all the numbers except "8" in a column? Filter out and average? Any help is ppreciated! -- happy world |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The sum and average function view all numbers as zero?? | Excel Discussion (Misc queries) | |||
| average of kth largest numbers in an array of n numbers | Excel Worksheet Functions | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Average of Numbers in Top 5 | Excel Discussion (Misc queries) | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
