Count problems[Excel 97]

[Tulkas]

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.

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

[Dave Peterson]

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