Counting the times multiple expressions on a row are met?

[Damgaard]

I have a table that looks something like this

#    A    B
1    1    3
2    2    3
3    2    1

I want to count the number of times Ax = 2 and Bx = 3. In this case, the result is 1, because only on row 2 are both the conditions met. I can use countif to find the number of times a column is equal 2, but I can’t see how to only count it if it’s neighbor also meets a condition. I suspect it might require using Array functions, but the documentation on this seem quite lacking and I’ve been unable to find any good tutorials for someone with a programming background. I will be very grateful for any help you can give me with solving this problem.

[JohnSUN]

1 Use array variant of function SUM:

{=SUM(($A$1:$A$3=2)*($B$1:$B$3=3))} (Ctrl+Shift+Enter!)

(See exaple of function SUM in Help )

2 Use function SUMPRODUCT

=SUMPRODUCT($A$1:$A$3=2;$B$1:$B$3=3)