Try...

=SUMPRODUCT(--(AccountRange=AcctNum),--(ISNUMBER(SEARCH("discover",Descri
ptionRange))),AmountRange)

Hope this helps!

In article ,
"Brian" wrote:

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?