count for different creteria in different columns

[Soe]

here is the data

a 1
b 2
c 1
a 3
a 2
c 3
a 1

like to count no of rows which has a and 1, in this case will be 2.
any advice?

 

[Arvi Laanemets]

=SUMPRODUCT((FirstRange="a")*(SecondRange=1))

(replace FirstRange and SecondRange with references to your data)


Arvi Laanemets