Spreadsheet: 123041d1317304881-how-do-i-total-mutiple-adjacent-values-using-a-string-search-lookup-1-
Sheet: Sheet1

 | Volume Group 1 |  | Size | Volume Group 2 |  | Size | Volume Group 3 |  | Size |  | Search | Storage | No. Of |  | Storage | No. Of
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) |  | Prefix | In Use | Entries |  | In Use | Entries
 | jan-vol1 |  | 20 | May the force be |  | 1 | february1 |  | 50 |  | jan | 287 | 2 |  | 287 | 2
 |  |  |  | June_data_1 |  | 140 |  |  |  |  | feb | 50 | 1 |  | 50 | 1
 |  |  |  | june-data-2 |  | 3 |  |  |  |  | [NAME] | 267 | 1 |  | 267 | 1
 |  |  |  | June Whitfield |  | 4 |  |  |  |  | Apr | 10 | 1 |  | 10 | 1
 |  |  |  |  |  |  |  |  |  |  | may | 1 | 1 |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | jun | 247 | 4 |  | 247 | 4
 |  |  |  |  |  |  |  |  |  |  | jul | 301 | 2 |  | 301 | 2
 |  |  |  |  |  |  |  |  |  |  | aug | 68 | 2 |  | 68 | 2
 |  |  |  |  |  |  |  |  |  |  | sep | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | oct | 50 | 1 |  | 50 | 1
 |  |  |  |  |  |  |  |  |  |  | nov | 140 | 1 |  | 140 | 1
 |  |  |  |  |  |  |  |  |  |  | dec | 220 | 3 |  | 220 | 3
 | Volume Group 4 |  | Size | Volume Group 5 |  | Size | Volume Group 6 |  | Size |  | mon | 40 | 1 |  | 40 | 1
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) |  | tue | 100 | 1 |  | 100 | 1
 | [NAME] |  | 267 | march data |  | 267 | July 4th Party |  | 267 |  | wed | 165 | 2 |  | 165 | 2
 |  |  |  | April data 1 |  | 10 | Jul-vol1 |  | 34 |  | thu | 170 | 2 |  | 170 | 2
 |  |  |  |  |  |  |  |  |  |  | fri | 53 | 1 |  | 53 | 1
 |  |  |  |  |  |  |  |  |  |  | 2001 | 71 | 2 |  | 71 | 2
 |  |  |  |  |  |  |  |  |  |  | 2002 | 101 | 1 |  | 101 | 1
 |  |  |  |  |  |  |  |  |  |  | 2003 | 505 | 1 |  | 505 | 1
 |  |  |  |  |  |  |  |  |  |  | 2004 | 1 | 1 |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 2005 | 125 | 1 |  | 125 | 1
 |  |  |  |  |  |  |  |  |  |  | 2006 | 200 | 1 |  | 200 | 1
 |  |  |  |  |  |  |  |  |  |  | 2007 | 645 | 1 |  | 645 | 1
 |  |  |  |  |  |  |  |  |  |  | 2008 | 570 | 1 |  | 570 | 1
 |  |  |  |  |  |  |  |  |  |  | 2009 | 1 | 1 |  | 1 | 1
 | Volume Group 7 |  | Size | Volume Group 8 |  | Size | Volume Group 9 |  | Size |  | 2010 | 310 | 2 |  | 310 | 2
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB)
 | August leave |  | 34 | Aug-vol1 |  | 34 | Octoberfest |  | 50
 | 2001 data |  | 18 | jun |  | 100 | November party |  | 140
 | 2010 data |  | 300
 | 2010 leave |  | 10
 |  |  |  |  |  |  |  |  |  |  |  | 4698 | 38 |  | 4698 | 38
 | Volume Group 10 |  | Size | Volume Group 11 |  | Size | Volume Group 12 |  | Size
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB)
 | dec1 |  | 100 | tues |  | 100 | thurs |  | 130
 | dec2 |  | 80 | Wednesday |  | 125 | Thursday adta |  | 40
 | dec3 |  | 40 | wedding day |  | 40 | fright night |  | 53
 | Monday |  | 40
 | Volume Group 13 |  | Size | Volume Group 14 |  | Size | Volume Group 15 |  | Size
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB)
 | 2001 party |  | 53 | 2004 -data |  | 1 | 2009 -vol1 |  | 1
 | 2003 data |  | 505 | 2006 -data |  | 200 | 2002 data |  | 101
 | 2005 data |  | 125 | 2008 -data |  | 570
 | 2007 -vol1 |  | 645