Re: $$Excel-Macros$$ sum/count the number of times a name has occured

How can i get automatic update of the privo tabel? Best Regards Peter On 12 Maj, 06:31, Vikas Chouhan wrote: > two way > > 1) put formula  =COUNTIF($A42:$A$8,"Bill") > 2) Make Pivot table > > > On Tue, May 11, 2010 at 1:00 PM, nyberg75 wrote: > > Hi &g

$$Excel-Macros$$ sum/count the number of times a name has occured

Hi How can i sum/count the number of times a name has occured Example: John Bill Gordon Bill Bill Sara Bill John Result: Bill = 4 times John = 2 times -- -- Some important links for excel users: 1. Follow us on TWI