I am trying to perform a conditional average with the following conditions:

ColumB is the document type, (i.e., change of address). Column E is the
source of the information (i.e., Internal, mail, etc). Column H is the
network day turn around (formula NETWORKDAYS).

Document_Type Source TAT
Address Change T 4
Address Change C 10
Address Change I 1


I am trying to get an average of all TATs for address changes that do NOT
include source codes C or I.

I am using Excel 2000, and I can get conditional sum to work with those
parameters, and I can get a basic "average if" function to work, but the
minute I try to exclude C and I, I get a value of 0, which is incorrect.

Anyone have any suggestions on a formula?

Thanks!