=AVERAGE(IF((Active!A10:A1000<--"2006-12-01")*(Active!M10:M1000="maint*"),Active!L10:L1000) )

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Heliocracy" wrote in message
...
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