Re: $$Excel-Macros$$ Two columns and three criteria

Hi, Just try it.. =SUMPRODUCT(--($A$1:A10=A1)--($A$1:A10=A2)*(B1:B10=B1)) On Thu, Sep 15, 2011 at 9:09 AM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (unfortunately, corporate > no spend policy): These columns have been exported from a database and > appear as the exa

Re: $$Excel-Macros$$ Two columns and three criteria

Hi ArtySin, Refer the attachment file for details. Hope That Helps! --- Ms.Exl.Learner --- On Thu, Sep 15, 2011 at 9:39 PM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (unfortunately, corporate > no spend policy): These columns ha

Re: $$Excel-Macros$$ Two columns and three criteria

Dear Arty, Please try it and see attached sheet.. =SUMPRODUCT(--($A$4:$A$13={"Passed","Failed"})*(B4:B13=H6)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Two columns and three criteria

Dear Arty, Run a pivot table and make the count of Passed, Failed on the specific date by removing the N/A from the filters. I hope you know how to run the pivot table. Regards Ahmed Bawazir On Thu, Sep 15, 2011 at 7:09 PM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (un

$$Excel-Macros$$ Two columns and three criteria

Hi I have two columns as below using Excel 2000 (unfortunately, corporate no spend policy): These columns have been exported from a database and appear as the example below. A B Status Date Run Passed 22/08/2011 Failed 22/08/2011 Failed 23/08/2011 Passed