Calculating 6 month average from dataset

[Alex]

I am calculating the previous six month average for
drought regions of different states.
Here is an example dataset:

No. ST Year AUG SEPT OCT NOV DEC JAN FEB
1 AZ 1989 1 3.4 3 0.2 3 3 4.4
1 AZ 1990 1 3.4 3 3 3 3 4.4
1 AZ 1991 1 3.4 -3 3 3 3 4.4
1 AZ 1992 1 3.4 3 3 3 3 4.4
2 AZ 1989 1 3.4 3 3 3 3 4.4
2 AZ 1990 1 3.4 3 3 3 3 4.4
2 AZ 1991 1 3.4 3 3 3 3 4.4
2 AZ 1992 1 3.4 3 3 3 3 4.4
1 NM 1989 1 3.4 3 3 3 3 4.4
1 NM 1990 1 3.4 3 3 3 3 4.4
1 NM 1991 1 3.4 3 3 3 3 4.4
1 NM 1992 1 3.4 3 3 3 3 4.4
2 NM 1989 1 3.4 3 3 3 3 4.4
2 NM 1990 1 3.4 3 3 3 3 4.4


How would I do this?

 

[Paul Corrado]

If you want the 6 month average for each row (state & year in your table)

then

=AVERAGE(E1:J1) where E1:J1 is the range of monthly data.

HTH

PC

 

[Alex]

I want the 6 month average for each row (state & year &
DROUGHT DIVISION). I am sorry that simple function does
not incorporate the division.

More Help needed. I can repost this.

Thanks for the attempt.
Alex

 

[Myrna Larson]

Have you considered a Pivot Table for this? Sounds like it may be ideal.