Try this

=COUNTIF(Sheet1!A1:A10,"x")

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kim-Anh Tran " wrote in message ...
Hello everyone,

In cell C1 of sheet 2, I need the count all "x" entries from cell
A1:A10 in sheet 1. _How_do_I_achieve_this?_

Thanks in advcance fo your help!

Regards,
Kim-Anh


---
Message posted from http://www.ExcelForum.com/