Assuming the server info to be in column A
=SUMIF(A:A,"Server 1",B:B)
This, of course cannot be in column A. But this could be:
=SUMIF(A2:A101,"Server 1",B2:B101)
provided it in not in range A2:A101
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Steve" wrote in message
...
I have a spreadsheet I use to log system outages when they occur and I
need
to sum them up together.
Example: Data Entered
Server 2 8/1/09 4.5 hours
Server 1 8/2/09 .5 hours
Server 2 8/2/09 .25 hours
Server 1 8/3/09 1.5 hours
What I want is to be able to automatically add the time up by Server so I
get this:
Server 1 Total hours 2.0 hours
Server 2 Total hours 4.75 hours
Can anyone assist please? I am not real strong in excel so any help would
be
greatly appreciated.
Thanks!