software

Hi

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

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!

If your number is in A8, enter in B8:
=SUMPRODUCT((A8=A$1:A$6)*(quot;ISMquot;=C$1:C$6))

HTH
--
AP

quot;Axelquot; gt; a écrit dans le message de
...
gt; Hi
gt;
gt; i need to know, how much people belongs to the number in Colum A - if in
gt; colum C is written quot;ISMquot;.
gt;
gt; A B C
gt; 1 1 Meier ISM
gt; 2 3 Huber ISM
gt; 3 2 Schmitz UPA
gt; 4 2 Mayer ISM
gt; 5 1 Mueller UPA
gt; 6 1 Hase ISM
gt;
gt; if somebody can help me, i would appreciate!

ABC FORMULA IN RESULT IN
D COLUMN
D COLUMN
11Meier ISM =IF(RIGHT(c2,3)=quot;ismquot;,A2,quot;quot;)....1
23Huber ISM =IF(RIGHT(c3,3)=quot;ismquot;,A3,quot;quot;).... 2
32Schmitz UPA =IF(RIGHT(c4,3)=quot;ismquot;,A4,quot;quot;).....
42Mayer ISM =IF(RIGHT(c5,3)=quot;ismquot;,A5,quot;quot;).... 4
51Mueller UPA =IF(RIGHT(c6,3)=quot;ismquot;,A6,quot;quot;).....
61Hase ISM =IF(RIGHT(c7,3)=quot;ismquot;,A7,quot;quot;).....6

HOPE THIS HELPS
REGARDS
VENRAM--
venram
------------------------------------------------------------------------
venram's Profile: www.excelforum.com/member.php...oamp;userid=33813
View this thread: www.excelforum.com/showthread...hreadid=535884As I read it, it only needs

=COUNTIF(A1:A8,quot;ISMquot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Ardus Petusquot; gt; wrote in message
...
gt; If your number is in A8, enter in B8:
gt; =SUMPRODUCT((A8=A$1:A$6)*(quot;ISMquot;=C$1:C$6))
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Axelquot; gt; a écrit dans le message de
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; i need to know, how much people belongs to the number in Colum A - if in
gt; gt; colum C is written quot;ISMquot;.
gt; gt;
gt; gt; A B C
gt; gt; 1 1 Meier ISM
gt; gt; 2 3 Huber ISM
gt; gt; 3 2 Schmitz UPA
gt; gt; 4 2 Mayer ISM
gt; gt; 5 1 Mueller UPA
gt; gt; 6 1 Hase ISM
gt; gt;
gt; gt; if somebody can help me, i would appreciate!
gt;
gt;
Thanks AP

but its not really what i want.

in the first step i tried countif(quot;$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 quot;ISMquot; and in colum A an 1 f.e.

THX
Axel

quot;Ardus Petusquot; wrote:

gt; If your number is in A8, enter in B8:
gt; =SUMPRODUCT((A8=A$1:A$6)*(quot;ISMquot;=C$1:C$6))
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Axelquot; gt; a écrit dans le message de
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; i need to know, how much people belongs to the number in Colum A - if in
gt; gt; colum C is written quot;ISMquot;.
gt; gt;
gt; gt; A B C
gt; gt; 1 1 Meier ISM
gt; gt; 2 3 Huber ISM
gt; gt; 3 2 Schmitz UPA
gt; gt; 4 2 Mayer ISM
gt; gt; 5 1 Mueller UPA
gt; gt; 6 1 Hase ISM
gt; gt;
gt; gt; if somebody can help me, i would appreciate!
gt;
gt;
gt;

Thanks venram

but its not really what i need.

in the first step i tried countif(quot;$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 quot;ISMquot; and in colum A an 1 f.e.

THX
Axel

quot;venramquot; wrote:

gt;
gt; ABC FORMULA IN RESULT IN
gt; D COLUMN D COLUMN
gt; 11Meier ISM =IF(RIGHT(c2,3)=quot;ismquot;,A2,quot;quot;)....1
gt; 23Huber ISM =IF(RIGHT(c3,3)=quot;ismquot;,A3,quot;quot;).... 2
gt; 32Schmitz UPA =IF(RIGHT(c4,3)=quot;ismquot;,A4,quot;quot;).....
gt; 42Mayer ISM =IF(RIGHT(c5,3)=quot;ismquot;,A5,quot;quot;).... 4
gt; 51Mueller UPA =IF(RIGHT(c6,3)=quot;ismquot;,A6,quot;quot;).....
gt; 61Hase ISM =IF(RIGHT(c7,3)=quot;ismquot;,A7,quot;quot;).....6
gt;
gt; HOPE THIS HELPS
gt; REGARDS
gt; VENRAM
gt;
gt;
gt; --
gt; venram
gt; ------------------------------------------------------------------------
gt; venram's Profile: www.excelforum.com/member.php...oamp;userid=33813
gt; View this thread: www.excelforum.com/showthread...hreadid=535884
gt;
gt;

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
quot;Bob Phillipsquot; wrote:

gt; As I read it, it only needs
gt;
gt; =COUNTIF(A1:A8,quot;ISMquot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Ardus Petusquot; gt; wrote in message
gt; ...
gt; gt; If your number is in A8, enter in B8:
gt; gt; =SUMPRODUCT((A8=A$1:A$6)*(quot;ISMquot;=C$1:C$6))
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;Axelquot; gt; a écrit dans le message de
gt; gt; ...
gt; gt; gt; Hi
gt; gt; gt;
gt; gt; gt; i need to know, how much people belongs to the number in Colum A - if in
gt; gt; gt; colum C is written quot;ISMquot;.
gt; gt; gt;
gt; gt; gt; A B C
gt; gt; gt; 1 1 Meier ISM
gt; gt; gt; 2 3 Huber ISM
gt; gt; gt; 3 2 Schmitz UPA
gt; gt; gt; 4 2 Mayer ISM
gt; gt; gt; 5 1 Mueller UPA
gt; gt; gt; 6 1 Hase ISM
gt; gt; gt;
gt; gt; gt; if somebody can help me, i would appreciate!
gt; gt;
gt; gt;
gt;
gt;
gt;

Try my response.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Axelquot; gt; wrote in message
...
gt; Thanks venram
gt;
gt; but its not really what i need.
gt;
gt; in the first step i tried countif(quot;$A$1:$C$1;1) and i got 3 people
gt; but thats not correct, because i only have to count the peolpe which have
in
gt; colum C written quot;ISMquot; and in colum A an 1 f.e.
gt;
gt; THX
gt; Axel
gt;
gt; quot;venramquot; wrote:
gt;
gt; gt;
gt; gt; A B C FORMULA IN RESULT IN
gt; gt; D COLUMN
D COLUMN
gt; gt; 1 1 Meier ISM =IF(RIGHT(c2,3)=quot;ismquot;,A2,quot;quot;)....1
gt; gt; 2 3 Huber ISM =IF(RIGHT(c3,3)=quot;ismquot;,A3,quot;quot;).... 2
gt; gt; 3 2 Schmitz UPA =IF(RIGHT(c4,3)=quot;ismquot;,A4,quot;quot;).....
gt; gt; 4 2 Mayer ISM =IF(RIGHT(c5,3)=quot;ismquot;,A5,quot;quot;).... 4
gt; gt; 5 1 Mueller UPA =IF(RIGHT(c6,3)=quot;ismquot;,A6,quot;quot;).....
gt; gt; 6 1 Hase ISM =IF(RIGHT(c7,3)=quot;ismquot;,A7,quot;quot;).....6
gt; gt;
gt; gt; HOPE THIS HELPS
gt; gt; REGARDS
gt; gt; VENRAM
gt; gt;
gt; gt;
gt; gt; --
gt; gt; venram
gt; gt; ------------------------------------------------------------------------
gt; gt; venram's Profile:
www.excelforum.com/member.php...oamp;userid=33813
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=535884
gt; gt;
gt; gt;
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
quot;Bob Phillipsquot; wrote:

gt; Try my response.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Axelquot; gt; wrote in message
gt; ...
gt; gt; Thanks venram
gt; gt;
gt; gt; but its not really what i need.
gt; gt;
gt; gt; in the first step i tried countif(quot;$A$1:$C$1;1) and i got 3 people
gt; gt; but thats not correct, because i only have to count the peolpe which have
gt; in
gt; gt; colum C written quot;ISMquot; and in colum A an 1 f.e.
gt; gt;
gt; gt; THX
gt; gt; Axel
gt; gt;
gt; gt; quot;venramquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; A B C FORMULA IN RESULT IN
gt; gt; gt; D COLUMN
gt; D COLUMN
gt; gt; gt; 1 1 Meier ISM =IF(RIGHT(c2,3)=quot;ismquot;,A2,quot;quot;)....1
gt; gt; gt; 2 3 Huber ISM =IF(RIGHT(c3,3)=quot;ismquot;,A3,quot;quot;).... 2
gt; gt; gt; 3 2 Schmitz UPA =IF(RIGHT(c4,3)=quot;ismquot;,A4,quot;quot;).....
gt; gt; gt; 4 2 Mayer ISM =IF(RIGHT(c5,3)=quot;ismquot;,A5,quot;quot;).... 4
gt; gt; gt; 5 1 Mueller UPA =IF(RIGHT(c6,3)=quot;ismquot;,A6,quot;quot;).....
gt; gt; gt; 6 1 Hase ISM =IF(RIGHT(c7,3)=quot;ismquot;,A7,quot;quot;).....6
gt; gt; gt;
gt; gt; gt; HOPE THIS HELPS
gt; gt; gt; REGARDS
gt; gt; gt; VENRAM
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; venram
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; venram's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33813
gt; gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=535884
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Sorry it should have been

=COUNTIF(C1:C8,quot;ISMquot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Axelquot; gt; wrote in message
...
gt; Thanks Bob,
gt;
gt; but the first column ist only the rownumbering of my examplespreedsheet.
gt; this system underpresses the leading spaces.
gt;
gt; A B C
gt; 1 Meier ISM
gt; 3 Huber ISM
gt; 2 Schmitz UPA
gt; 2 Mayer ISM
gt; 1 Mueller UPA
gt; 1 Hase ISM
gt;
gt; maybe now its more clearly. i have two criterias column A and column C
gt;
gt; THX
gt; Axel
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; As I read it, it only needs
gt; gt;
gt; gt; =COUNTIF(A1:A8,quot;ISMquot;)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Ardus Petusquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; If your number is in A8, enter in B8:
gt; gt; gt; =SUMPRODUCT((A8=A$1:A$6)*(quot;ISMquot;=C$1:C$6))
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt; --
gt; gt; gt; AP
gt; gt; gt;
gt; gt; gt; quot;Axelquot; gt; a écrit dans le message de
gt; gt; gt; ...
gt; gt; gt; gt; Hi
gt; gt; gt; gt;
gt; gt; gt; gt; i need to know, how much people belongs to the number in Colum A -
if in
gt; gt; gt; gt; colum C is written quot;ISMquot;.
gt; gt; gt; gt;
gt; gt; gt; gt; A B C
gt; gt; gt; gt; 1 1 Meier ISM
gt; gt; gt; gt; 2 3 Huber ISM
gt; gt; gt; gt; 3 2 Schmitz UPA
gt; gt; gt; gt; 4 2 Mayer ISM
gt; gt; gt; gt; 5 1 Mueller UPA
gt; gt; gt; gt; 6 1 Hase ISM
gt; gt; gt; gt;
gt; gt; gt; gt; if somebody can help me, i would appreciate!
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;