Thanks AP

but its not really what i want.

in the first step i tried countif("$A$1:$C$1;1) and i got 3 people
but thats not correct, because i only have to count the peolpe which have in
colum C written "ISM" and in colum A an 1 f.e.

THX
Axel

"Ardus Petus" wrote:

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!