Using Countif with multiple criteria

[JustLearning]

I have a workbook that I need to count occurances of a cell value based on
multiple criteria --i.e. the count is valid only if all criteria is met. I
have tried to use sumproduct, but I get a #N/A result, but I know that the
arrays are of the same length. The only thing that I suspect is that the
arrays are sparse --i.e. not evey value is present. How can I count the
number of occurances in this example?

[Bob Phillips]

#N/A normally occurs if the arrays are different sizes, or the data contains
#N/A. Post your formula and some data.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"JustLearning" <[email protected]> wrote in message
news:[email protected]...
> I have a workbook that I need to count occurances of a cell value based on
> multiple criteria --i.e. the count is valid only if all criteria is met. I
> have tried to use sumproduct, but I get a #N/A result, but I know that the
> arrays are of the same length. The only thing that I suspect is that the
> arrays are sparse --i.e. not evey value is present. How can I count the
> number of occurances in this example?