average formula

E

earlyd

Well-known Member

Joined

Dec 10, 2002

Messages

1,199

• Sep 19, 2003

• #2

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

 

Upvote 0

E

earlyd

Well-known Member

Joined

Dec 10, 2002

Messages

1,199

• Sep 19, 2003

• #3

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

 

Upvote 0

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Sep 19, 2003

• #4

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

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Sep 19, 2003

• #5

calliroi said:

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

Click to expand...

=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.

 

Upvote 0