View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Collecting and summing data

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!