Count problems[Excel 97]
 

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

The COUNTA(D1:D100) function will count all non-blank cells in the range
D1:D100. The COUNTIF(D1:D100,"bla") will count how many times the text
"bla" occurs in the range D1:D100.

That should work for you unless I missed something.


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

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