Conditional Average
 

Hi all,

I have 28 worksheets in a workbook, for this example they are named 1
through 28. Each worksheet has one cell that will either have a cell
(a1) that will display PU, CL, DFT, FT, and PJ. There is a cell (a2)
beneath it that has a numerical value between 1 - 100. I want to be
able to write a forumula that checks cell a1 in every worksheet to
average a2 if i'm looking for PU, CL,DFT, FT, or PJ. Thanks.