Re: $$Excel-Macros$$ Need Help with IF(AND formula

Thank you! On Tue, Nov 22, 2011 at 10:30 AM, Jedi Spencee wrote: > Hello- I am trying to write a formula that would return the COUNT and > SUM, with 3 criteria elements. > > IF(AND(data!F:F = "A"),and(data!B:B, = "04 - Closed Won"), and(data! > D:D, = Oct-11)

$$Excel-Macros$$ Need Help with IF(AND formula

Hello- I am trying to write a formula that would return the COUNT and SUM, with 3 criteria elements. IF(AND(data!F:F = "A"),and(data!B:B, = "04 - Closed Won"), and(data! D:D, = Oct-11),count, "0") Can this be done? Thank you. -- FORUM RULES (934+ members already BANNED for violation) 1) Use