Okay I've got dates in column A, column L has the number of days since the
column A date, and column N has text that says either "maint*" or "ent*."
I'm using the following formula to calculate the average number of days in
column L for specific dates in column A:

=(SUMIF(Active!A10:A1000,"<39052",Active!L10:L1000 ))/(COUNTIF(Active!A10:A1000,"<39052"))

It seems to work fine--I get the average number of days that items dated
before 12/2006 have listed in column L.

Now, I need to get the average number of days listed in column L for records
where both the date in column A is before 12/2006, AND the text in column M
is "maint*." It's too many variables to get my head wrapped around. Can
anyone please help? Hope this is clear enough...

Thanks,
Mike