Find string then sum a range offset from that

[cw1013]

Surely this has been asked, but I couldn't find the exact issue searching:

I've got a bunch of dynamic, personalized spreadsheets I'm trying to get some templated data out of. To do that, I need to search Column A for a string, then move over a column, down a few rows and add a vertical range. I have no problem finding the address of the cell with the string, and I have no problem getting the sum of the range if I manually enter that location, but I cannot seem to get the two pieces to work together.

Here's some sample data:

[TABLE="width: 154"]
<tbody>[TR]
[TD]Data[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]Store 2[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]Store 3[/TD]
[TD="align: right"]300[/TD]
[/TR]
</tbody>[/TABLE]

I need to find "Data" and then sum the relative B3:B5.

 

[pgc01]

Hi

Try:

=SUM(OFFSET(B1,MATCH("data",A:A,0)+1,,3))