VBA Count value of table column and paste with text

[Melimob]

Hi

I have a table with a total row.

On another worksheet, I want to either count the text values of that row or read from the total row.

As the total row may not always be present, I thought it best instead to count the text of column?

I want to present this value in another worksheet as

Potential Clients (no)

Or if it's easier I can write 'Potential Clients' and have the value in a cell next to it?

thanks for any advice.