Cell value, and respective count. (for statistical and graphic use)

A pivot table where
"food" is the row label and
"count of food" is in the values field.

Basic intro to creating pivot tables: http://www.excel-easy.com/data-analy...ot-tables.html

If that doesn't work for you,try countifs

The basic pivot table tools can compute count, average, max, min, standard deviation, and variance, among other things. Your OP only asked about counting words, with no other context or detail about what you need this analysis to do. The results of a pivot table can be fed into other formulas and functions to perform further calculations. A pivot table can be a good way to analyze data and to get the data needed for further analysis. Beyond that, I'm not sure much can be said without understanding more of the context around this calculation you are trying to perform.

As Ford noted, most pivot table calculations can also be acheived through other worksheet functions. That can be preferable in many contexts. One would need to understand where this "count" operation fits into your larger analysis algorithm.

Thanks guys, im a little bit further now.

Still got a few questions:

Datasheet1 contains a lot of different data and has multiple column names :

Header	empty for clarity purposes	header	header
Header in chinese		Header in chinese	Header in chinese
values		values	values

Now when i select the data it doesn't work, i had to delete the chinese translation row, as a temporary solution.
Also I need a better way to split the table caches, to make groups.
At the moment i press ALT+D+T or something and then change the range, and then change it back.

What are ways to SELECT the whole datasheet mentioned above for dynamic tables.

Thanks in advance.