Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D11:D40))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you