IFAND then SUM

  • Thread starter Thread starter Seree
  • Start date Start date
S

Seree

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
 
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
 
Back
Top