Simple array formula not working

Hi to all. I´m kinda new to array formulas, and I can´t seem to make this one work.

Given a worksheet called "tabla" where all my data is, I´m building a dashboard in another worksheet called "dashboard". So, here is what I am trying to do:

I´m trying to count the rows which contain in column I (status) the term "pipeline", and in column U (Campaign) the term "MR", so here´s the formula I used:

{=SUM((Tabla!I:I="Pipeline")*(Tabla!U:U="MR"))}

The result I get, instead of the nubmer of rows with "Pipeline" status and belonging to the "MR" Campaign is: #NUM! so I guess I am doing something wrong.

Can anyone help please? I´m using Excel 2000.

Thank you

Alejandro

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.

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

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.