Hi all,

Okay, may be a easy solution but this has been driving me nuts as a novice.

I have a three column bank statement which follows:

Column a = date of transaction
column b = description of transaction (normally a line of text)
column c = amount

Now on a separate worksheet in the same document i want to be able to run a formula that returns a value for the amount spent in a certain date range on particular types of transaction.

For example:

- Value returned for wages spent in march
- Value returned for atm withdrawls in march.

For example I may have transactions described as "BILL PAYMENT TO J DENNEY WAGE REFERENCE J Denney MANDATE NO 0013"on the statement. So as well as the date range query I would want to run the query with 'contains' "denney wage". Now this is where i get stuck, as i have no idea how to run a contains formula, rather than equals. Especially one that allows me to search for a part string of text rather than exact.

Any help appreciated.

Ta

James