It looks like =countif() would work for you:

=countif(d1:d10,"bla")

Debra Dalgleish has lots of info about counting cells at:
http://www.contextures.com/xlFunctions04.html



Tulkas wrote:

Hi there,

I did a search on the forum to find an answer to my question but didn't
find anything.

Here is my prob :

Lets say I got this page-

___a___b_____c__d__
1 Name Type Job bla
2 Name Type Job bla
3 Name Type Job bla
4 Name Type Job bla
5 Name Type Job bob

I want a Cell to write how many row I got( 5 in this exemple) and only
count the cells with bla in the D column(4 in this exemple).

Sorry if I'm not really clear but if you can help me feel free to
answer :)

thx,
Tulkas.

--
Tulkas
------------------------------------------------------------------------
Tulkas's Profile: http://www.excelforum.com/member.php...o&userid=24386
View this thread: http://www.excelforum.com/showthread...hreadid=379763

--

Dave Peterson