Thread
:
Finding Number of cells in a column of other sheet having a specific word in them
View Single Post
#
6
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
You're very welcome. Thanks for the feedback.
--
Regards
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, 2:24 pm, "Sandy Mann" wrote:
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
groups.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- Hide quoted text -
- Show quoted text -
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann