Thank you Ashish and Viswanathan very much. Problem solved. John
On Sun, Mar 27, 2011 at 2:28 AM, ashish koul <koul.ash...@gmail.com> wrote: > check the attachment see if it helps > > > On Sun, Mar 27, 2011 at 11:18 AM, ashish koul <koul.ash...@gmail.com>wrote: > >> >> >> On Sun, Mar 27, 2011 at 5:51 AM, Viswanathan M <vis...@gmail.com> wrote: >> >>> Dear Mr. John, >>> =SUM(NOT(B2=""),NOT(D2=""),NOT(F2="")) >>> The above formula will help you for finding out the Total Deliveries >>> *With warm regards* >>> *Viswanathan M* >>> DE(Tech) >>> RGM TTC Chennai-600027 >>> *Vande* *Mataram* >>> >>> >>> On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith >>> <johnasmit...@gmail.com>wrote: >>> >>>> I have an excel database where each line represents an entity and it's >>>> data over about 70 columns. There are multiple occurrences of delivery >>>> information in these columns that I need to summarize in a pivot table. >>>> Some lines may have only one occurrence of this delivery while some others >>>> may have three or four. >>>> >>>> Please see my example attached. Thank you for your continuing help. >>>> >>>> John >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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 >>>> >>> >>> >>> >>> -- >>> *With warm regards* >>> *Viswanathan M* >>> DE(Tech) >>> RGM TTC Chennai-600027 >>> *Vande* *Mataram* >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >> >> >> P Before printing, think about the environment. >> >> >> > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- ---------------------------------------------------------------------------------- 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