Counting multiple cell values! Please help!

[Kim-Anh Tran]

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

 

[Ron de Bruin]

Try this

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

 

[Kim-Anh Tran]

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