Thanks for the tip though, I´ll try it anyway. Always good to know more than 1 way to do things.

Quote Originally Posted by BigBas
i just ran a quick sample, and this worked for me, i hope you can incorporate it:


=COUNT(IF(I1:I10="pipeline",IF(U1:U10="mr",A1:A10)))

validate this by hitting ctrl+shift+enter

let me know if it works

EDIT: I posted too late. Glad you fixed your problem.