I assume I use a lookup function, but not sure. I would define the range
with a name, I know that much, but the formula stumps me. I have a list that
could read something like this:

JAN Con-Way 2
JAN SFS 3
APR SFS 3
JUN SFS 3
JUL TransX 4
JAN Yellow 4
JAN Yellow 4
JAN Yellow 4
JAN Yellow 4
SEP TransX 5
FEB Yellow 5
FEB Yellow 5

In another cell, for example, I would like to put a formula that would look
up all of "Yellow" in this list and then give me the average of the numbers
for Yellow. I think it's simple enough but I'm not versed enough! Connie