maybe use........

=SUM(C1:E1,G1:I1,K1:M1)/9

Vaya con Dios,
Chuck, CABGx3


"GJR3599" wrote in message
...
i'm trying to take a total average over multiple columns that arent next
to
each other for specific rows. I have a list of entries each with a label
of
for example "Red Sox", "Yankees", "Orioles","Blue Jays" etc. I'm trying to
average a bunch of columns for all the "Red Sox" but the columns aren't
next
to each other. For example i need columns C-E, G-I, and K-M. I have taken
the
averages for all "Red Sox" within each section (C-E for example) by using
the
function {=IF($B7=0,0,AVERAGE(IF(Southeast!$B$11:$B$99=$A7, G$11:I$99)))}
where B is the column containing team names, A7 is the identification "Red
Sox" and G-I are the columns of data. How do I do multiple arrays????