I want to search for the text in a cell from a column in another sheet, some
of the text will be common but not the same ie Daily Fees in cell, data sheet
will say Daily Fees 6 June 08, or D/E in cell and D/E 14589 in Data Sheet,
How to i create a formula that can search for the words i want in that
column, then return a sum total of everything matched from the amount column.

eg Sheet 1 Sheet 2 - Data Sheet
Description Total
Daily Fees $40.00 Daily Fees 1/6/08 $20.00
Daily Fees 2/6/08 $20.00
D/E $50.00 D/E 245878 $5.00
D/E 45784
$45.00