I thought that you said that the numbers were just row numbers, so where
does 1 come from?

If you have 1,2, etc. in column A then use

=SUMPRODUCT(--(A$1:A$6=1),--(C$1:C$6="ISM"))

as Ardus suggested.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Axel" wrote in message
...
Hi Bob

if i do, what you responsed then i the result is 4, but in reality its 2;
because of the two criterias (in column A=1 and in column C=ISM)

THX
Axel
"Bob Phillips" wrote:

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