Countif, two criterias need help
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!
|