I want to count the number of times a contact appears in a column, how do I do that?

Ddyer

So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!

Brent Wilson

@Ddyer

The COUNTIF function is all you need

=COUNTIF([Name]:[Name], "John Smith")

So you don't have to keep retyping the formula

=COUNTIF([Name]:[Name], [Name]@row)

But really the PIE chart functionally will do this without any formula. Just point it at the name and it will do that out of the box

Brent Wilson

@Ddyer

The COUNTIF function is all you need

=COUNTIF([Name]:[Name], "John Smith")

So you don't have to keep retyping the formula

=COUNTIF([Name]:[Name], [Name]@row)

But really the PIE chart functionally will do this without any formula. Just point it at the name and it will do that out of the box

Ddyer

@Brent Wilson perfect! Worked great. Thank you!