* Thanks sir,,, but i wanna sum for the same .. formula which is sent u 1stly its not working proprly so can u send it in 2nd sheet .. plz do the needful.
* On Tue, Dec 21, 2010 at 3:40 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear Rakesh, > > you can use Sumproduct for same output... > Please see attachments.. > > > =SUMPRODUCT(($A$2:$A$1081=$H3)*($C$2:$C$1081=I$2)*($B$2:$B$1081)) > > -- > Thanks & regards, > Noorain Ansari > On Tue, Dec 21, 2010 at 12:32 AM, Rakesh Sharma > <rksharma...@gmail.com>wrote: > >> * >> >> >> Dear Sir, >> >> >> Plz if any other formula... plz >> >> >> >> * >> >> >> On Tue, Dec 21, 2010 at 12:46 PM, NOORAIN ANSARI < >> noorain.ans...@gmail.com> wrote: >> >>> Dear Rakesh, >>> >>> Please see attached sheet.. >>> >>> Thanks, >>> Noorain Ansari >>> >>> On Mon, Dec 20, 2010 at 11:02 PM, Rakesh Sharma <rksharma...@gmail.com >>> > wrote: >>> >>>> * >>>> HI, >>>> >>>> >>>> help required as mention in sheet.... >>>> >>>> >>>> Thanks in adv... >>>> Rakesh sharma >>>> 09906115140 >>>> >>>> >>>> * >>>> >>>> On Sat, Dec 18, 2010 at 6:53 PM, Richard <richard.m...@gmail.com>wrote: >>>> >>>>> Create a sub called "sub workbook_open" in "this workbook" and call >>>>> your macro. >>>>> >>>>> On Dec 18, 3:34 am, "C.G.Kumar" <kumar.bemlmum...@gmail.com> wrote: >>>>> > I want a macro to run every time when an excel file is opened. >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> 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 >>>>> >>>> >>>> >>>> >>>> -- >>>> Regards >>>> Rakesh Sharma >>>> >>>> >>>> >>> >>> >>> >>> >>> >> >> >> -- >> Regards >> Rakesh Sharma >> >> >> > > > -- > Thanks & regards, > Noorain Ansari > > -- Regards Rakesh Sharma -- ---------------------------------------------------------------------------------- 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