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
>
> > How can i sum/count the number of
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
>
> 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
Hello Dear,
You can use countif in range,attached workbook has a sample formula.
On Wed, May 12, 2010 at 1:30 AM, nyberg75 wrote:
> 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 tim
Assuming your list of names are in A2:A6
=COUNTIF($A42:$A$6,"Bill")
returns the number of "Bill" in your above mentioned range.
On May 12, 3:00 am, nyberg75 wrote:
> Hi
> How can i sum/count the number of times a name has occured
> Example:
> John
> Bill
> Gordon
> Bill
> Bill
> Sara
>
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
