Thank you for your time. I am not sure I completely understand...the D2:D200
reference is what is being averaged and the C cell references are the
criteria, correct?
I adapted it to this ...........
{=AVERAGE(IF('Sheet 1'!$B$1:$B$500="10/01/2004",'Sheet
1'!$B$1:$B$500<="12/31/2004",'Sheet 1'!$D$1:$D$500))}
but am getting the same result regardless of the dates I put in. Can you
help with that?
I have also tried =AVERAGE(IF('Sheet 1'!$B$1:$B$500="10/01/2004",'Sheet
1'!$B$1:$B$500<="12/31/2004"),'Sheet 1'!$D$1:$D$500) but it also gives me the
same result no matter what dates are entered. And thanks for the reminder
about the "control+ shift+enter"

"Don Guillett" wrote:

adapt this array formula to your criteria. Don't forget to use
ctrl+shift+enter for entering/editing.

=AVERAGE(IF(ChecksA=O1,ChecksA<O2,ChecksD))

=AVERAGE(IF(a2:a200=O1,a2:a200<O2,d2:d200))

Don Guillett
SalesAid Software

"kathi" wrote in message
...
I have a column with open date (B), column with closed date (C), column
with
count of days opened (D).
I need to calculate the average number of days each were opened in the
1st,
2nd, 3rd and 4th quarter of the fiscal year as well as the entire fiscal
year.
I have been physicallly typing in each cell reference that has an opening
date int he first quarter, but would like to be able to say SUM COLUMN D
ONLY
IF COLUMN B "=10/01/2004" also "<=12/31/2004".
THEN COUNTIF COLUMN B ONLY IF "=10/01/2004" ALSO "<=12/31/2004"