$$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

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://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Dec 9, 2011 at 8:03 AM, Darwin

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

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