Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

try sumproduct. SUMPRODUCT((A2:A31=A35)*(B2:B31=B35)*C2:C31) On Thu, Jul 28, 2011 at 11:57 AM, Venkat CV wrote: > Hi Mohan, > > If you want to get the data based on Multiple Criteria in 2007 You May Try > Countifs,Sumifs,Averageifs > > *Best Regards,* > *Venkat* > * > * > * > * > > On Thu, Jul

Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

Hi Mohan, If you want to get the data based on Multiple Criteria in 2007 You May Try Countifs,Sumifs,Averageifs *Best Regards,* *Venkat* * * * * On Thu, Jul 28, 2011 at 8:38 AM, Mohanraj shunmugam wrote: > dear team member, > > i need formula for multiple criteria to find specfic value > > i

Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

=SUMIFS($C$2:$C$31,$A$2:$A$31,A35,$B$2:$B$31,B35) On Thu, Jul 28, 2011 at 8:38 AM, Mohanraj shunmugam wrote: > dear team member, > > i need formula for multiple criteria to find specfic value > > i here attach sample file > my question on sample file is > how to find fundvalue for date 15/07/20

$$Excel-Macros$$ need formula for find specif value based on multiple crteria

dear team member, i need formula for multiple criteria to find specfic value i here attach sample file my question on sample file is how to find fundvalue for date 15/07/2011 and fund id 20 need formula help me thanking you regards, mohanraj s -- --