Apologies Hans, an error in my last post, the range should be split from the
criteria with a comma not a semi-colon. I've also just tried with a range,
and it doesn't seem to work, so you might need to do this function on each
sheet, and then sum them at the end.

"hans" wrote:

I want to know how often a name (say jack) occurs in a spreadsheet.
The name has to be found in the range c6:f40 but.........
i have 50 sheets. named 1, 2, 3, 4, .......50
and i want to know the sum of how often a name occurs in all sheets
together.

Can someone help me?
Greetings Hans