Finding Number of cells in a column of other sheet having a specific word in them

  • Thread starter Thread starter ch.rajashekar
  • Start date Start date
C

ch.rajashekar

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
 
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk







- Show quoted text -
Click to expand...

Hi Sandy,
I get a popup window saying the formula that i typed contains error.I
am not able to fix this problem

Thanks and Regards,
Raja Shekar
 
Does your Excel version use semi-colons in place of commas? If so try
replacing the comma.

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Does your Excel version use semi-colons in place of commas? If so try
replacing the comma.

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk








- Show quoted text -
Click to expand...

Hi Sandy,
I tried using semi-colon instead of comma and it is working
fine ..thank you very much for your help...
With Warm Regards,
Raja Shekar
 
You're very welcome. Thanks for the feedback.

--
Regards

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top