find alpha in column 1 numeric column 2

[JANeyer]

Might be basic question, but I am having brain cramp!!! I am trying to
count the number of times in a sheet column 1 = 10 AND column 2 = South. I
have tried multiple version of the count, and, if, countif etc, but can not
figure it out. Please advise

 

[Tyro]

=SUMPRODUCT((A1:A10=10)*(B1:B10="South"))

Tyro

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A1:A100=10),--(B1:B100="south"))

Better to use cells to hold the criteria:

D1 = 10
E1 = south

=SUMPRODUCT(--(A1:A100=D1),--(B1:B100=E1))