Re: $$Excel-Macros$$ sum base on 8 digits code

2012-07-05 Thread Divaker Pandey
*Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *pawel lupinski > *Sent:* 05 July 2012 1:56 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ sum

RE: $$Excel-Macros$$ sum base on 8 digits code

2012-07-05 Thread Rajan_Verma
-Macros$$ sum base on 8 digits code Hi All, I need your help on this particular task. Does anyone know how to add up this value? I have bigger table that I need to add all codes started with first the same 8 digits rest of the digits are not important as this is only combination of the main first 8

Re: $$Excel-Macros$$ sum base on 8 digits code

2012-07-04 Thread pawel lupinski
Hi Noorain,   Full respect, great solution, many thanks   Pawel From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, July 5, 2012 4:10 AM Subject: Re: $$Excel-Macros$$ sum base on 8 digits code Hi Lupinski, Please use it.. =SUMIF($E$5