hi Thanks 4 ur reply,it was a sample what i required, in the actual data its around 300 items in it the data will never in the order.Formula given under is giving a correct answer in my actual database, but it have auto filling problem
=SUMIF(R8:R96,a12,(X8:X96)) =SUMIF(R8:R96,a13,(X8:X96)) =SUMIF(R8:R96,a14,(X8:X96)) i want fill down the formula in this order how can i do, in this only criteria have to change, but the range is same for all cells Regards Rajesh kainikkara On 12/15/10, Daniel <dcolarde...@free.fr> wrote: > Hi, > 1. Formula should be (in H3 : > =SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3,DAMAGE!B2:B5) > 2. The drinks in column A should be in the same order on each sheet. > Regards. > Daniel > > -----Message d'origine----- > De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De > la part de Rajesh K R > Envoyé : mercredi 15 décembre 2010 13:02 > À : excel-macros > Objet : $$Excel-Macros$$ problem in sumif > > Hi Experts > > Pls find the attachment ,& tell me whats wrong in the formula > > STOCK SUMMERY - 1 st sheet > OPENING PURCHASE SALE BALANCE > COLA 1000 250 700 550 > SODA 500 100 300 300 > WATER 400 150 100 450 > > DAMAGE STOCK - 2 nd sheet > SODA 20 > COLA 5 > WATER 4 > > > STOCK SUMMERY ADJUSTED - 3 rd sheet > OPENING PURCHASE SALE GOOD DAMAGE > BALANCE > SODA 1000 250 700 530 > 20 550 > COLA 500 100 300 295 > 5 300 > WATER 400 150 100 446 > 4 450 > > > SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3:A5,(DAMAGE!B2:B5)) > I tried the above formula in the column damage in 3 rd sheet , but it shown > only wrong values, kindly tell me how correct the formula. > > Regards > Rajesh kainikkara > > -- > ---------------------------------------------------------------------------- > ------ > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts