R
rivethead
Each month I get an Excel spreadsheet with 2 columns. The first colum
is a list of servers(many of them repeated) and the second colum
states how much disk space was allocated to the corresponding server.
I'd like to find an easy way to add all the disk space for eac
individual server. Here is how it looks using a : as a column gri
line.
server1:40
server1:20
server1:45
server1:300
server1:18
server2:65
server2:40
server2:11
server2:345
What is the easiest way to add together each of server1's disk spac
(server 2, etc..) for a grand total for each server?
I'm using Excel ver. 2002.
Thanks
is a list of servers(many of them repeated) and the second colum
states how much disk space was allocated to the corresponding server.
I'd like to find an easy way to add all the disk space for eac
individual server. Here is how it looks using a : as a column gri
line.
server1:40
server1:20
server1:45
server1:300
server1:18
server2:65
server2:40
server2:11
server2:345
What is the easiest way to add together each of server1's disk spac
(server 2, etc..) for a grand total for each server?
I'm using Excel ver. 2002.
Thanks