counting in one column when two expressions in two other columns are true
 

Hi Group

I am trying to count in one column when two other columns are true

example:

a b c
1 D E F
2 G H I
3 D J F

I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2

Can anyone help?

Regards

Henrik

try
=sumproduct((a2:a200="A")*(c2:c200="f"))

--
Don Guillett
SalesAid Software

"Henrik" wrote in message
...
Hi Group

I am trying to count in one column when two other columns are true

example:

a b c
1 D E F
2 G H I
3 D J F

I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2

Can anyone help?

Regards

Henrik

One way:

=SUMPRODUCT(--(A1:A3="D"),--(C1:C3="F"))

See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of
the "--".


In article ,
"Henrik" wrote:

Hi Group

I am trying to count in one column when two other columns are true

example:

a b c
1 D E F
2 G H I
3 D J F

I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2

Can anyone help?

Regards

Henrik

Thanks guys!

It's now working.


rgds

Henrik

"Henrik" skrev i en meddelelse
...
Hi Group

I am trying to count in one column when two other columns are true

example:

a b c
1 D E F
2 G H I
3 D J F

I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2

Can anyone help?

Regards

Henrik