IFAND then SUM
 

I'm trying to come up with a formula to check if this is true in column A AND
that is true in column B then SUM column C for corresponding rows.
Here's part of my array.

Dates Fees
App: 02/02/2010 Charged $251.00
RAL: 02/02/2010 Paid $251.00
AR/ADD: Due $0.00
App: 02/08/2010 Charged $39.00
RAL: Paid $0.00
AR/ADD: Due $39.00
App: 02/03/2010 Charged $428.00
RAL: 02/03/2010 Paid $428.00
AR/ADD: Due $0.00
App: 02/02/2010 Charged $416.00
RAL: Paid $416.00
AR/ADD: 02/02/2010 Due $0.00

In other words, IF Dates = *02/16/2010 AND column B = "Paid" then SUM Fees.
Is this even possible to do in Excel 2003?

Thanks in advance for your help,
Seree

IFAND then SUM
 

Try this:

=SUMPRODUCT(--(ISNUMBER(SEARCH("02/16/2010",A$2:A$100))),--(B$2:B
$100="Paid"),C$2:C$100)

Adjust the ranges to suit your data.

Hope this helps.

Pete

On Feb 18, 2:15*am, Seree wrote:
I'm trying to come up with a formula to check if this is true in column A AND
that is true in column B then SUM column C for corresponding rows.
Here's part of my array.

Dates * * * * * * * * * Fees * *
App: 02/02/2010 Charged * * * * $251.00
RAL: 02/02/2010 Paid * * * * * *$251.00
AR/ADD: * * * * * * * * * * * * Due * * * * * * $0.00 *
App: 02/08/2010 Charged * * * * $39.00 *
RAL: * * * * * * * * * *Paid * * * * * *$0.00 *
AR/ADD: * * * * * * * * * * * * Due * * * * * * $39.00 *
App: 02/03/2010 Charged * * * * $428.00
RAL: 02/03/2010 Paid * * * * * *$428.00
AR/ADD: * * * * * * * * * * * * Due * * * * * * $0.00 *
App: 02/02/2010 Charged * * * * $416.00
RAL: * * * * * * * * * *Paid * * * * * *$416.00
AR/ADD: 02/02/2010 * * *Due * * * * * * $0.00 *

In other words, IF Dates = *02/16/2010 AND column B = "Paid" then SUM Fees.
Is this even possible to do in Excel 2003?

Thanks in advance for your help,
Seree