count for different creteria in different columns

  • Thread starter Thread starter Soe
  • Start date Start date
S

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?
 
=SUMPRODUCT((FirstRange="a")*(SecondRange=1))

(replace FirstRange and SecondRange with references to your data)


Arvi Laanemets
 
Back
Top