Get Aerage based on unique Name

[rdirvingjr]

I have a large spreadsheet (5 columns x 450,000 rows). Column headings are:
ServerName, Date, Time, CPU usage & AvgCPU. Each server is a unique name, with multiple CPU usage numbers. I would like to be able to get the avg CPU usage for each unique server. Right now I manually scoll down to see where the next server's data starts, highlight the range of numbers for that server and then enter a formula to calculate the avg CPU usage.

Is there a way to automtically extract all the unique server names and then tell excell to average the CPU usage for that server name?

HELP please
Dean

[rdirvingjr]

P.S. The number of entries for each servers varies. In other words, one server could have 350 rows of data, another server 12, etc, etc.
Dean

[Whizbang]

Use AVERAGEIF()

=AVERAGEIF(A:A,"Server 1",D:D)

Oops.

In 2003 it would be

=Average(If(A1:A65536="Server 1",D1:D65536))

Note that this is an array formula, however. Instead of hitting "Enter" to confirm, you would press CTRL+SHIFT+ENTER

Second edit:
You could also do subtotals (Data - SubTotals) and set it to give you the average of the CPU Usage column.