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