Im trying to create a formula to find the average of a list of numbers, based on a type of classification. I have three different classifications of workers (temp, permanent, and administrative) with a score of 1 to 5 in one column, and have 18 different rows (one row for every individual worker). I want to get the average of the scores, but i only want to take the average of the scores for each classification. For example, there are 6 temp workers, but instead of just putting in =average(A1:A6) I want to make some kind of function that measures the whole range of numbers, and takes the average IF the worker is temp, or permanent, or admin. I tried to do this with =AVERAGEA but I couldn't get it to work.

Any help would be greatly appreciated!

PS To further complicate things, Im doing all this in Spanish, so anyone who can give me the Excel formulas in Spanish will win the Gold Medal for "Excel Badass".