On Tue, 30 Jan 2007 07:40:01 -0800, Abdelmoneim,Mahmoud
wrote:

Hi all,
I have a file contain 10 sheets,every sheet contain list of names,i need to
know the frequncy of certian name all over the 10 sheets.

Thanks

If you will be referring to no more than 65,536 cells, you could download and
install Longre's free and easily distributable add-in morefunc.xll from
http://xcell05.free.fr/

Then use the COUNTIF.3D function.


--ron