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