| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average of numbers in column between to other numbers
If i have a big column of numbers, and i would want to select that column and
find the averages of all the numbers in that column that are between 0 and 500, how would i type that formula? Thanks! |
|
#2
|
|||
|
|||
|
One way
=AVERAGE(IF((A1:A20000)*(A1:A2000<500),A1:A2000)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Ditandhischeese" wrote in message ... If i have a big column of numbers, and i would want to select that column and find the averages of all the numbers in that column that are between 0 and 500, how would i type that formula? Thanks! |
|
#3
|
|||
|
|||
|
=(SUMIF(A:A,"0",A:A)-SUMIF(A:A,"500",A:A))/(COUNTIF(A:A,"0")-COUNTIF(A:A,
"500")) All on one line, watch out for email word-wrap Vaya con Dios, Chuck, CABGx3 "Ditandhischeese" wrote in message ... If i have a big column of numbers, and i would want to select that column and find the averages of all the numbers in that column that are between 0 and 500, how would i type that formula? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Worksheet Functions | |||
Linear Mode
