Spreadsheet: 123030d1317300570-how-do-i-total-mutiple-adjacent-values-using-a-string-search-lookup
Sheet: Sheet1

 | Volume Group 1 |  | Size | Volume Group 2 |  | Size | Volume Group 3 |  | Size |  | Search | Storage | No. Of |  | Group1 | Group2 | Group3 | Group4 | Group5 | Group6 | Group7 | Group8 | Group9 | Group10 | Group11 | Group12 | Group13 | Group14 | Group15
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) |  | Prefix | In Use | Entries |  | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals | Totals
 | jan-vol1 |  | 20 | May the force be |  | 1 | february1 |  | 50 |  | jan | 287 | 2 |  | 20 | 0 | 0 | 267 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | June_data_1 |  | 140 |  |  |  |  | feb | 50 | 1 |  | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | june-data-2 |  | 3 |  |  |  |  | [NAME] | 267 | 1 |  | 0 | 0 | 0 | 0 | 267 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | June Whitfield |  | 4 |  |  |  |  | apr | 10 | 1 |  | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | may | 1 | 1 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | jun | 247 | 4 |  | 0 | 147 | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | jul | 301 | 2 |  | 0 | 0 | 0 | 0 | 0 | 301 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | aug | 68 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 34 | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | sep | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | oct | 50 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | nov | 140 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 140 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | dec | 220 | 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 220 | 0 | 0 | 0 | 0 | 0
 | Volume Group 4 |  | Size | Volume Group 5 |  | Size | Volume Group 6 |  | Size |  | mon | 40 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) |  | tue | 100 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 0
 | [NAME] |  | 267 | march data |  | 267 | July 4th Party |  | 267 |  | wed | 165 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 165 | 0 | 0 | 0 | 0
 |  |  |  | April data 1 |  | 10 | Jul-vol1 |  | 34 |  | thu | 170 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 170 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | fri | 53 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 2001 | 71 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 53 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 2002 | 101 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 101
 |  |  |  |  |  |  |  |  |  |  | 2003 | 505 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 505 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 2004 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  | 2005 | 125 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 125 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 2006 | 200 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 0
 |  |  |  |  |  |  |  |  |  |  | 2007 | 645 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 645 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 2008 | 570 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 570 | 0
 |  |  |  |  |  |  |  |  |  |  | 2009 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Volume Group 7 |  | Size | Volume Group 8 |  | Size | Volume Group 9 |  | Size |  | 2010 | 310 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 310 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) | Virtual Disks (RAID5) |  | (GB) |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 | August leave |  | 34 | Aug-vol1 |  | 34 | Octoberfest |  | 50 |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 | 2001data |  | 18 | jun |  | 100 | November party |  | 140 |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 | 2010 data |  | 300 |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 | 2010 leave |  | 10 |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 20 | 148 | 50 | 267 | 277 | 301 | 362 | 134 | 190 | 260 | 265 | 223 | 1328 | 771 | 102
 |  |  |  |  |  |  |  |  |  |  |  | 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)
 | 2001party |  | 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