Mohawk,
I think what you want to do is easily handled with some nested formulas, however, I'm not exactly sure what you want. Do you want the average of the numbers in columnB where ColumnA has a certain value or do want to take the average of all the values in columnB if a certain value exists...