Excel query

[RumbleBee]

Hope someone can help with this.

Is there a formula for counting how many times a particular word appears in a column and displaying the results which will autoupdate when new additions are made.

Quick example with 5 rows

paris
madrid
paris
madrid
london

My formula needs to show Paris = 2, and if I add another row with paris the formula will auto update to 3 and so on.

Thanks,
Andy

 

[Nanobot]

Similar one here.

 

[Col_M]

you want COUNTIF

e.g. =COUNTIF(A2:A500,"Paris")
Will give you the number of cells from A2 to A500 that have the word Paris in them.

Edit:
If you're going to be adding a lot of rows it may be better to set the range as A:A that'll save you running out of rows. Just be aware that it'll count everything meeting the condition so make sure you don't have Paris written in any cells in column A above or below the table, common sense really