average formula

[calliroi]

I need help with the average formula:

ex: i have a column with 6,000 records.....i want to average the records in the same column that have lets say $300-$1000...is that possible

 

[earlyd]

=(SUMIF(I6:I12,">300") - SUMIF(I6:I12,">1000"))/(COUNTIF(I6:I12,">300") - COUNTIF(I6:I12,">1000"))

 

[earlyd]

Above solution's range obviously has to be changed to allow for your 6000 entries.

 

[Iridium]

Without knowing more about how your s/s is set up you could try

http://www.mrexcel.com/tip011.shtml
http://www.cpearson.com/excel/lists.htm

HTH

 

[Aladin Akyurek]

I need help with the average formula:

ex: i have a column with 6,000 records.....i want to average the records in the same column that have lets say $300-$1000...is that possible

=AVERAGE(IF(($A$2:$A$6001>=300)*($A$2:$A$6001<=1000),$A$2:$A$6001))

which must be confirmed with control+shift+enter, not just with enter.