Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

Thanks Noorain, I got the problem solved!! 2011/12/9 NOORAIN ANSARI > > Dear Darwin, > > Please see attached sheet. Hope it will help you.. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.

Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

Dear Darwin, Please see attached sheet. Hope it will help you.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Dec 9, 2011 at 8:03 AM, Darwi

$$Excel-Macros$$ Sumproduct for multiple criteria lookup

Dear group, I have got an excel file getting sales volume of different customers in buying different services on a daily basis. I want to use sumproduct formula to get the sales volume buying services on a monthly basis. However, the desired results are not found. Please help. -- Darwin Chan da