Copy and paste the below formula:- =SUMIF($R$8:$R$96,$A12,($X$8:$X$96))
Drag the formula cell below to the remaining cells and the criteria cell will be getting changed and the Range and Sum Range will remains same. But past the above formula other than R8:R96, X8:X96 range and A12 cell. Otherwise you will get circular reference error. Hope it's clear to you! ----------------------- Ms.Exl.Learner ----------------------- On Thu, Dec 16, 2010 at 4:08 PM, Rajesh K R <rajeshkainikk...@gmail.com>wrote: > 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 > -- -- ---------------------------------------------------------------------------------- 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