Thread
:
Finding Number of cells in a column of other sheet having a specific word in them
View Single Post
#
4
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
Finding Number of cells in a column of other sheet having a specific word in them
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
with @tiscali.co.uk
wrote in message
oups.com...
On Feb 21, 12:17 pm, "Sandy Mann" wrote:
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- Hide quoted text -
- Show quoted text -
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann