I would avoid array formulas and simply use;
=SUMIF(C1:C100,"dog",H1:H100)/COUNTIF(C1:C100,"dog")


--
Regards
Dave Hawley
www.ozgrid.com

"Curtis" .(do not spam) wrote in message
...
I need to a formula that will look at column c and if it contains a certain
text say "dog" I want to average the price located in column H

Thanks
--
ce