With the Description in Column C, and the Amounts in Column D, try this:

=SUMIF(C1:C100,"*discover*",D1:D100)

If you would like to reference a particular cell, so that you can change the
description of the account you're looking to sum, try thiis, with the acct.
description entered in E1:

=SUMIF(C1:C100,"*"&E1&"*",D1:D100)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Brian" wrote in message
...
I have a spreadsheet with the following columns....Date, Account,
Description
and Amount.
I'd like to create a lookup formula whereby all data in the Amount column
will be added together if they are deposited in a specific account and the
description has the word "Discover" in it.
I am semi-familiar with array formulas, but the problem I have is that the
Description column has several words in it, and I want the formula to only
pickup rows that have the word Discover in the description field.
How can I get this to work?