"And" will return true/false, try using IF(AND(-------)) which will return a
value as the criteria.

Regards
Steve

"rwtrader" wrote in message
...
I am having trouble adding an AND statement to the condition portion of the
AVERAGEIF statement. Is there a trick to doing this?