Conditional MIN and AVERAGE

[babsc01]

Happy Friday! Has anyone ever messed around with compiling a VBA project to mimic the Conditional Sum Wizard? I've messed around with the Wizard to try other arguments, such as MAX, MIN, AVG, etc. The only one that seems to work is MAX:

{=MAX(IF($C$2:$C$681>11031,$E$2:$E$681,0))} 

MIN and AVERAGE don't work, however. I would think they would...oh well.

Have a great weekend...and THANKS.