Count problems[Excel 97]

T

Tulkas

Hi there,

I did a search on the forum to find an answer to my question but didn'
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 onl
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 t
answer :)

thx,
Tulkas
 
M

MrShorty

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.
 
Top