X
xtrmhyper
hello to all excel expert
i want to all "D" column and get the average
criteria is in column A must be ="X"
B >=10/01/05 and <=10/31/05
C <>0
A B C D
X 10/01/05 0 1
X 10/01/05 0.012 6
X 10/01/05 0.012 2
o 10/01/05 0.012 1
X 11/01/05 0.012 1
i want to all "D" column and get the average
criteria is in column A must be ="X"
B >=10/01/05 and <=10/31/05
C <>0
A B C D
X 10/01/05 0 1
X 10/01/05 0.012 6
X 10/01/05 0.012 2
o 10/01/05 0.012 1
X 11/01/05 0.012 1