Count the number of occurances of a particular value
Hi all,
The case is as below
Say in Column A the values are like this
FH01
FH01
FH02,FH01
FH03
FH04,FH01
So there is one column and 5 rows.
I need to count how many "FH01" are there.
The answer should be 4 and not 2.
I tried using Countif(range, "FH01") it returned only 2.
Please hepl
Use
=COUNTIF(A1:A100,"*FH01*")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
thank you very much
.........................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks