Calculating 6 month average from dataset

  • Thread starter Thread starter Alex
  • Start date Start date
A

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?
 
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
 
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
 
Back
Top