manipulating data

[Pandab2002]

I have a spreadsheet with two columns and 30 rows of data. Column A contains titles and column b contains mostly numbers. I am only concerned with certain rows. The rows in column A that I am concerned with all contain the phrase "XFER 1". I need to add the data in the neighboring cells in column b. Below is an example. I want to extract the sum of the three cells in column b that are next to the "XFER 1" cells in column a. Keep in mind that the cells are not always in this order. Sometimes there are four or five "XFER 1" cells.

Can anyone assist?

SiteName Anytown, USA
UserSiteID 999
Partition 1
DateRetrieved 1/6/2005 13:38
Invalid Count 470
Abort Count 83
Timeout Count 520
Star Count 559
Pound Count 0
XFER 1 30
XFER 1 126
2-2TMF 4 777
3-3:CMD 2 4377
4-4:CMD 3 1732
5-5TMF 13 209
6-6:XFER 3 398
7-7TMF 15 108
8-8:XFER 2 4037
0-0:XFER 2 2687
AUTO node # 2
Invalid Count 304
Abort Count 0
Timeout Count 1987
Star Count 0
Pound Count 0
0-0:XFER 20 95
XFER 1 1197

 

[Zathras]

[tt]
=SUMIF(A1:A30,"XFER 1",B1:B30)
[/tt]