Counting multiple cell values! Please help!
 

Hello everyone,

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

Thanks in advcance fo your help!

Regards,
Kim-An

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

Counting multiple cell values! Please help!
 

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/

Counting multiple cell values! Please help!
 

Your help is well appreciated!
Have a wonderful day!
Regards,
Kim-An

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