extract data from sheet2 into sheet1

[Just2learn]

I have a workbook with two sheets. Sheet1 is simple it has a list of customers and a total column. Sheet2 has all the customers data. I need to pull the total by customer from sheet2 into sheet1. The problem I am having is the customer total cell on sheet2 is not always in the same place. i.e. the data may be on one line as in A ONE FURNITURE, or more than one as in the STARSHINE BEST line.

A ONE FURNITURE LLC 332.79
CUSTOMER TOTAL: 332.79

STARSHINE BEST LLC AR2198-0209 72129 619.94
STARSHINE BEST LLC FREIGHT CHARGE/P 721289 0
STARSHINE BEST LLC GA1803-0214 72240 1805.64
STARSHINE BEST LLC FREIGHT CHARGE/D 72239L 0
STARSHINE BEST LLC MI2203-0307 72486 328
STARSHINE BEST LLC FREIGHT CHARGE/P 724850 0
CUSTOMER TOTAL: 2753.58

BACKYARD PLEASURES 3963 72330 639
BACKYARD PLEASURES 3963 72331 8434.48
BACKYARD PLEASURES FREIGHT CHARGE/P72329 0
BACKYARD PLEASURES 3963 72420 3592.34
CUSTOMER TOTAL: 12665.82

I need to pull these customer totals into sheet1 that matches the customers name. There may be as many 900 customer names on sheet1. Any help would be greatly appreciated.....

 

[Just2learn]

I tried the sumif before posting to the forum but it returned zeros at times when it should have returned a sum I could not figure out why it wouldn't sum.

 

[Haseeb Avarakkan]

In Sheet2!B:B at the end of the customer name should have a space. Try this

=SUMIF(Sheet2!B:B,$A2&"*",Sheet2!F:F)

 

[Just2learn]

It seems so easy now...I believe I learned something about (&"*") when you put the star inside the quotes is that what says leave a space at the end? Thanks for the solution now I can go to bed. Thank you....

 

[Haseeb Avarakkan]

A2&"*" means If there is anything after the value in A2, spaces other charracter or anything., it would SUM. If doesn't have anything after A2 value in Sheet2!B:B still SUM this customer.

See excel help or search google about wild card characters

 

[Just2learn]

Copied that into my notes, thank you for taking time out of your day to help me. Much appreciated....