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 mohanraj2...@gmail.comwrote: dear team member, i need formula for multiple criteria to find

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 venkat1@gmail.com 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

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

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 mohanraj2...@gmail.comwrote: 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