Collecting and summing data

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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