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