Without googling it...

In Excel, how do you count the number of times a particular string appears in a range of cells?

You're allowed, nay encouraged, to use the "help" facility, including the ever helpful paperclip.

(Oh, using your finger and going 'one, two, three..' doesn't count! :) I'm looking for a formula.)

It must be a fairly frequent need and I'm curious as to how many people know or can use the "help" to find out. When I get home, I'll see if the lovely OpenOffice is any better.

Without googling it... #2

( Answer beneath here )