countif from two columns

[James]

I need to count when day column in Monday and value column
is 200, example somthing like:
countif ((A:A,"Monday") and (B:B,"200"))

This formulae does not work as it is, how must i modify it
to make it work?

 

[acw]

James

=sumproduct((a1:a500="Monday")*(b1:b500=200))
Unfortunately you cannot use the complete column selection
in this function.

Tony

 

[james]

Thanks,

This works perfectly.
The tip that i cannot use the complete column also helped
me solve other problems.

James.

 

[james]

Thanks,

This works perfectly.
The tip that i cannot use the complete column also helped
me solve other problems.

James.