Use SUMPRODUCT(), it can handle multiple columns and multiple criteria:

=SUMPRODUCT(--(A1:A1000="James"),--(B1:B1000="x"))

See:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Gary''s Student - gsnu200800


"Russell" wrote:

I can use COUNTIF to determine the number of times a name shows up in a
column. I want a formula that will determine the number of times that a
certain name in a row also has a lower case x in another column in the same
row. I cannot figure out how to use two COUNTIFs in the same formula.

Thank you for your help.
--
Russell