Let us know how it works out.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom K" wrote in message
...
On Jan 12, 5:33 pm, "Don Guillett" wrote:
Try this. Be sure to array enter by using ctrl+shift+enter instead of just
enter

=AVERAGE(IF((A2:A22="china")*(B2:B22="lost"),C2:D2 2))

Excellent! This may save me loads of time - thank you!