Hello all please can you help me. I have a spreadsheet with 3 columns and I would like to identify all cells that start with the letter B and would like to add up a selection of the data held in each cell. The numbers to add up are all of the last numbers prior to the letter D on the end of the string, if that makes sense. I've included a sample of the data which is only 3 columns and would very much appreciate anyone's help. Kind regards
[TABLE="width: 994"]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H00173551 0[/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NJOHN W.ADAMS [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]N4 LAIRGATE [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]NBEVERLEY [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]N [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD]N [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD]NHU17 8EE [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD]D161221160628PEN A00174471 150930 JOHN W.A1612200000150000D 0000150000[/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]9[/TD]
[TD][/TD]
[TD]B00173551 00000000000150000D[/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H01947473 0[/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NWOOD [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]N16 IRVING STREET [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]NLEICESTER SQUARE [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]NLONDON [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD]N [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD]NWC2H 7AU [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD]D170612160930PEN A00281685 151231 WOODBLOX1706080000300000D 0000300000[/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]9[/TD]
[TD][/TD]
[TD]B01947473 00000000000300000D[/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H02815204 0[/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NSTAMPER FARMS LIMITED [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]NWEST FARM OFFICE, WEST FARM [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]NBARNHAM [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]NTHETFORD [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD]NNORFOLK [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD]NIP24 2PL [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD]D150813140228PEN A000349438130531 STAMPER 1507310000300000D 0000300000[/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]9[/TD]
[TD][/TD]
[TD]B02815204 00000000000300000D[/TD]
[/TR]
[TR]
[TD]02934906 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H02934906 0[/TD]
[/TR]
[TR]
[TD]02934906 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NTECHNICAL SUPPORT[/TD]
[/TR]
[TR]
[TD]02934906 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]NCHAR HOUSE [/TD]
[/TR]
[/TABLE]
[TABLE="width: 994"]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H00173551 0[/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NJOHN W.ADAMS [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]N4 LAIRGATE [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]NBEVERLEY [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]N [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD]N [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD]NHU17 8EE [/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD]D161221160628PEN A00174471 150930 JOHN W.A1612200000150000D 0000150000[/TD]
[/TR]
[TR]
[TD]00173551 [/TD]
[TD][/TD]
[TD]9[/TD]
[TD][/TD]
[TD]B00173551 00000000000150000D[/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H01947473 0[/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NWOOD [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]N16 IRVING STREET [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]NLEICESTER SQUARE [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]NLONDON [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD]N [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD]NWC2H 7AU [/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD]D170612160930PEN A00281685 151231 WOODBLOX1706080000300000D 0000300000[/TD]
[/TR]
[TR]
[TD]01947473 [/TD]
[TD][/TD]
[TD]9[/TD]
[TD][/TD]
[TD]B01947473 00000000000300000D[/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H02815204 0[/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NSTAMPER FARMS LIMITED [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]NWEST FARM OFFICE, WEST FARM [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]NBARNHAM [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]NTHETFORD [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD]NNORFOLK [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD]NIP24 2PL [/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD]D150813140228PEN A000349438130531 STAMPER 1507310000300000D 0000300000[/TD]
[/TR]
[TR]
[TD]02815204 [/TD]
[TD][/TD]
[TD]9[/TD]
[TD][/TD]
[TD]B02815204 00000000000300000D[/TD]
[/TR]
[TR]
[TD]02934906 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]H02934906 0[/TD]
[/TR]
[TR]
[TD]02934906 [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]NTECHNICAL SUPPORT[/TD]
[/TR]
[TR]
[TD]02934906 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]NCHAR HOUSE [/TD]
[/TR]
[/TABLE]