Your formula works for me. What is the actual error that youm are getting,
#Value! #Ref! or what?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


wrote in message
oups.com...
Hello ,
I would like to get the data,the number of cells in column H of sheet2
with value "open" in them, into one of the cell of sheet1. I tried
to use
COUNTIF(SHEET2!H:H,"open") ..but it is giving error.
Please help me out ..

Thanks in advance.
Raja Shekar