Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |