Sorry it should have been

=COUNTIF(C1:C8,"ISM")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Axel" wrote in message
...
Thanks Bob,

but the first column ist only the rownumbering of my examplespreedsheet.
this system underpresses the leading spaces.

A B C
1 Meier ISM
3 Huber ISM
2 Schmitz UPA
2 Mayer ISM
1 Mueller UPA
1 Hase ISM

maybe now its more clearly. i have two criterias column A and column C

THX
Axel
"Bob Phillips" wrote:

As I read it, it only needs

=COUNTIF(A1:A8,"ISM")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ardus Petus" wrote in message
...
If your number is in A8, enter in B8:
=SUMPRODUCT((A8=A$1:A$6)*("ISM"=C$1:C$6))

HTH
--
AP

"Axel" a écrit dans le message de
...
Hi

i need to know, how much people belongs to the number in Colum A -
if in
colum C is written "ISM".

A B C
1 1 Meier ISM
2 3 Huber ISM
3 2 Schmitz UPA
4 2 Mayer ISM
5 1 Mueller UPA
6 1 Hase ISM

if somebody can help me, i would appreciate!