Averaging Multiple Groups

dirty_pirate

New Member
Joined
Jul 30, 2004
Messages
7
Hello All,

I am working with a large data set and I need to know the average value for each site but I would prefer not to have to do them individually. I would like a method for computing the averages automatically. Below is a sample of the data set for your review

Site Temp
GAN-02-04 19.44
GAN-02-04 19.62
GAN-02-04 13.43
GAN-24-04 12.35
GAN-24-04 11.35
GAN-24-04 9.81
GAN-20-04 17.46
GAN-20-04 18.65
GAN-20-04 11.12
GAN-26-04 17.09
GAN-01-04 19.16
GAN-01-04 18.91
GAN-01-04 12.02
GAN-19-04 15.61
GAN-07-04 14.57
GAN-13-04 15.64
GAN-22-04 18.89
GAN-22-04 18.14
GAN-22-04 13.57
GAN-11-04 14.07
GAN-11-04 14.44
GAN-11-04 11.91
GAN-28-04 17.18
GAN-30-04 18.27
GAN-17-04 14.07
GAN-15-04 14.22
GAN-15-04 14.91
GAN-15-04 10.99
GAN-12-04 15.4
GAN-12-04 15.92
GAN-12-04 11.45
GAN-14-04 19.07
GAN-06-04 14.57
GAN-09-04 15.56
GAN-21-04 20.33
GAN-05-04 14.7
GAN-05-04 15.35
GAN-05-04 11.77
GAN-16-04 15.68
GAN-25-04 19.15
GAN-25-04 18.55
GAN-25-04 13.9
GAN-27-04 18.35
GAN-27-05 17.19
GAN-27-05 11.49
GAN-33-04 14.79
GAN-08-04 15.62
GAN-08-04 15.2
GAN-08-04 11.22
GAN-31-04 18.08
GAN-31-05 17.56
GAN-31-05 11.29
GAN-23-04 18.44
GAN-23-04 16.68
GAN-23-04 10.99
GAN-18-04 12.38
GAN-18-04 11.22
GAN-18-04 9.76
GAN-10-04 17.37
GAN-29-04 20.62
GAN-34-04 13.6
GAN-34-04 11.05
GR-01-03 12.13
GR-01-03 20.09
GR-01-03 18.24
GR-01-03 19
GR-01-03 7.49
GR-02-03 11.99
GR-02-03 20.55
GR-02-03 17.72
GR-02-03 18.01
GR-02-03 6.88
GR-03-03 10.74
GR-03-03 18.01
GR-03-03 17.18
GR-03-03 17.22
GR-03-03 7.25
GR-04-03 11.84
GR-04-03 19.8
GR-04-03 17.82
GR-04-03 17.9
GR-04-03 6.5
GR-05-03 13.43
GR-05-03 24.05
GR-05-03 18.72
GR-05-03 19.55
GR-05-03 7.5
GR-06-03 10.9
GR-06-03 18.26
GR-06-03 16.27
GR-06-03 16.65
GR-06-03 7.64
GR-07-03 10.64
GR-07-03 15.46
GR-07-03 15.81
GR-07-03 16.22
GR-07-03 7.97
GA-01-03 10
GA-01-03 14.49
GA-01-03 14.78
GA-01-03 14.89
GA-01-03 6.77
GA-02-03 10.86
GA-02-03 14.66
GA-02-03 14.9
GA-02-03 15.09
GA-02-03 7.31
GA-03-03 13.4
GA-03-03 17
GA-03-03 18.69
GA-03-03 18.57
GA-03-03 9.81
GA-04-03 11.28
GA-04-03 15.26
GA-04-03 16.2
GA-04-03 15.88
GA-04-03 7.67
GA-05-03 11.49
GA-05-03 14.35
GA-05-03 15.5
GA-05-03 15.77
GA-05-03 7.94
GA-06-03 12.93
GA-06-03 16.04
GA-06-03 16.95
GA-06-03 16.58
GA-06-03 8.45
GA-07-03 10.22
GA-07-03 11.19
GA-07-03 12.98
GA-07-03 13.45
GA-07-03 7.45
GA-08-03 12.05
GA-08-03 13.9
GA-08-03 16.35
GA-08-03 16.71
GA-08-03 8.05
GA-09-03 12.47
GA-09-03 14.03
GA-09-03 17.96
GA-09-03 17.48
GA-09-03 7.32
CO-01-03 12.03
CO-01-03 15.5
CO-01-03 17.18
CO-01-03 17.16
CO-01-03 6.56
CO-02-03 12.44
CO-02-03 16.43
CO-02-03 18.1
CO-02-03 18.4
CO-02-03 6.71
CO-03-03 12.31
CO-03-03 15.73
CO-03-03 16.81
CO-03-03 17.34
CO-03-03 7.21

Thanks in advance
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,450
Not sure about this, but try;

=AVERAGE(IF(SiteRange="Site",TempRange))

entered with CTRL+SHIFT+ENTER
 

Forum statistics

Threads
1,077,864
Messages
5,336,846
Members
399,105
Latest member
idleminutes

Some videos you may like

This Week's Hot Topics

Top