how to count the nr of occurrences of a text string in a cell rang


G

Guest

I have a list of people in a table, one person's details per row including
their address - each address is held in a single multi-line cell. There are
no merged cells in the tableEach address ends with a country name (UK,
Germany, France, Italy, etc)
Thus I have a column of address cells.
I want to be able to summarise under the table the number of people
registered per country. ie one line with the total for UK, one for France,
etc. I started off looking at COUNT functions, to achieve something like:
COUNTxx (IF( cell in <range x:y> contains "<country name eg UK> ...."))
but I can't find a function that allows me to search a cell for the
occurrence of a specific string in this way
Any ideas?
 
Ad

Advertisements

R

Ron Rosenfeld

I have a list of people in a table, one person's details per row including
their address - each address is held in a single multi-line cell. There are
no merged cells in the tableEach address ends with a country name (UK,
Germany, France, Italy, etc)
Thus I have a column of address cells.
I want to be able to summarise under the table the number of people
registered per country. ie one line with the total for UK, one for France,
etc. I started off looking at COUNT functions, to achieve something like:
COUNTxx (IF( cell in <range x:y> contains "<country name eg UK> ...."))
but I can't find a function that allows me to search a cell for the
occurrence of a specific string in this way
Any ideas?

Use COUNTIF. You may use wildcards in defining the text string.
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top