find alpha in column 1 numeric column 2

J

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
 
T

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))
 
Top