Collecting and summing data
 

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!

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!

Collecting and summing data
 

Have a look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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!

Collecting and summing data
 

Thanks to both of you for sumif....that did the job!

"Steve" wrote:

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!