Try my response.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Axel" wrote in message
...
Thanks venram

but its not really what i need.

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

"venram" wrote:


A B C FORMULA IN RESULT IN
D COLUMN
D COLUMN
1 1 Meier ISM =IF(RIGHT(c2,3)="ism",A2,"")....1
2 3 Huber ISM =IF(RIGHT(c3,3)="ism",A3,"").... 2
3 2 Schmitz UPA =IF(RIGHT(c4,3)="ism",A4,"").....
4 2 Mayer ISM =IF(RIGHT(c5,3)="ism",A5,"").... 4
5 1 Mueller UPA =IF(RIGHT(c6,3)="ism",A6,"").....
6 1 Hase ISM =IF(RIGHT(c7,3)="ism",A7,"").....6

HOPE THIS HELPS
REGARDS
VENRAM


--
venram
------------------------------------------------------------------------
venram's Profile:
http://www.excelforum.com/member.php...o&userid=33813
View this thread:
http://www.excelforum.com/showthread...hreadid=535884