Hi Ashish koul, I have seen many of your replies and it mostly contains Sumproduct formula. i checked this formula in Microsoft Help (MS Help) and it seems very easy thing. but what you use in your answer is very much different than what is given in the MS help. could u please explain why and what is this different.
i am giving both formulas. MS Help:- =SUMPRODUCT(A2:B4, C2:D4) in the above formula A col is multiplied with C col and B col is multiplied with D col and their products get added Your Formula:- =SUMPRODUCT(($G$4:$I$10=C4)*ROW($G$4:$I$10)) if i type =ROW($G$4:$I$10) i get 4 wherever i paste this formula. you always use this * sign whereas this is not given in the MS help. could you please explain your formula in plain English. please please please explain your logic i have spend lot of time on this but really couldn't get anything :( Thanks in advance. -- ---------------------------------------------------------------------------------- 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
