|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 31st, 2005, 02:35 AM
|
|||
|
|||
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
March 31st, 2005, 03:10 AM
|
|||
|
|||
|
One way
=AVERAGE(IF((A1:A20000)*(A1:A2000500),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
March 31st, 2005, 03:35 AM
|
|||
|
|||
|
=(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!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Splitting Numbers in a Column | jer101 | General Discussion | 3 | October 4th, 2004 10:53 PM |
| Separating letters and numbers from same column? | Manfred | General Discussion | 3 | September 16th, 2004 07:47 AM |
| adding numbers in column if criteria met | Barb | General Discussion | 2 | September 9th, 2004 05:22 PM |
Linear Mode
