Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IFAND Formula | Excel Discussion (Misc queries) | |||
Multiple "IFAND" | Excel Discussion (Misc queries) | |||
Multiple "IFAND" | Excel Discussion (Misc queries) | |||
Q about: IfAnd or is it AndIf? | Excel Worksheet Functions | |||
Add 2nd variable to if statement - ifAnd? | Excel Worksheet Functions |