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