find alpha in column 1 numeric column 2
 

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

find alpha in column 1 numeric column 2
 

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

Tyro

"JANeyer" wrote in message
...
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

find alpha in column 1 numeric column 2
 

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


--
Biff
Microsoft Excel MVP


"JANeyer" wrote in message
...
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