RE: $$Excel-Macros$$ need formula to summarize based on multiple crteria

2011-07-28 Thread Omar
=VLOOKUP(B35;B25:C31;2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anwar Mohd Sent: Thursday, July 28, 2011 6:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need formula to summarize based on multiple crteria Hi Experts,

Re: $$Excel-Macros$$ need formula to summarize based on multiple crteria

2011-07-27 Thread Shiek Peer Mohd
Hi, Thanks a lot for quick reply. It works well. Regards Anwar On Thu, Jul 28, 2011 at 11:24 AM, §»VIPER«§ wrote: > Hi Anwer > > pfa. it may help > > -- > *Great day,* > *viper > * > > > On Thu, Jul 28, 2011 at 10:17 AM, Anwar Mohd wrote: > >> Hi Experts, >> >> I need a formula to summar

Re: $$Excel-Macros$$ need formula to summarize based on multiple crteria

2011-07-27 Thread §»VIPER«§
Hi Anwer pfa. it may help -- *Great day,* *viper * On Thu, Jul 28, 2011 at 10:17 AM, Anwar Mohd wrote: > Hi Experts, > > I need a formula to summarize based on multiple crteria as per the attached > sheet. > > From the data sheet i need to summarize partner revenue based on the > winprob%