Hi, You are using array formula i.e.=MIN(IF($A$2:$A$12>=E2;IF($A$2:$A$12<=F2;IF($B$2:$B$12=D2;$C$2:$C$12;"")))) & =AVERAGE(IF($A$2:$A$12>=E2;IF($A$2:$A$12<=F2;IF($B$2:$B$12=D2;$C$2:$C$12;"")))).
Is there any way to do this without using array formula. Thanks, Chandra Shekar B On Fri, May 20, 2011 at 2:24 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > There is no array used.. > > > > Regards, Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* Thursday, May 19, 2011 7:25 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct > > > > Hi, > > > > Thanks for the reply. Can we do this without using array function. > > > > Regards, > > > > Chandra Shekar B > > On Thu, May 19, 2011 at 11:16 AM, Anil Bhange < > anil.bha...@tatacommunications.com> wrote: > > HI Chandra, > > > > See if it helps… > > > > Regards, Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* Wednesday, May 18, 2011 7:51 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct > > > > Hi Asish, > > > > Please reply to the mail. :) > > > > I have attached both the files for your information. > > > > Regards, > > > > Chandra Shekar B > > On Tue, May 17, 2011 at 7:34 PM, Chandra Shekar < > chandrashekarb....@gmail.com> wrote: > > Hi Ashish, > > > > Please find attached file. > > > > Thanks, > > > > Chanra Shekar B > > On Tue, May 17, 2011 at 6:09 PM, ashish koul <koul.ash...@gmail.com> > wrote: > > i have made changes in the data may be because of that can you attach the > sample file back > > > > On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar < > chandrashekarb....@gmail.com> wrote: > > Hi Asish, > > > > Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN > & AVG for first record should be 100, 50 & avergage should be 87.5. > > > > Can we use sumproduct for all the formulas instead of array formulas. > Thanks in advanc. > > > > Regards, > > > > Chandra Shekar B > > On Mon, May 16, 2011 at 9:15 PM, ashish koul <koul.ash...@gmail.com> > wrote: > > try this > > > > On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar < > chandrashekarb....@gmail.com> wrote: > > Hi, > > > > I want Min Max and Average by using Sumproduct. My problem is I want a > formula which should be based on Date and Title as shown on Column D, E & F > and based on Column C I need Average, Min & Max Values. If I confusing pls > let me know. > > > > Thanks > > > > Chandra Shekar B > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > -- > > *Regards* > > * * > > *Ashish Koul* > > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > > *akoul*.wordpress.com <http://akoul.wordpress.com/> > > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > > P Before printing, think about the environment. > > > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > > *Regards* > > * * > > *Ashish Koul* > > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > > *akoul*.wordpress.com <http://akoul.wordpress.com/> > > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > > P Before printing, think about the environment. > > > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
