=sumproduct(--(a1:a10="missing"),--(b1:b10="joe"))
Adjust the ranges to match--but you can't use whole columns (except in xl2007).
=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.
Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html
TMF in MN wrote:
I'm sure this is easy, but not for me.
A B
MISSING JOE
MISSING JOE
ENTERED LINDA
MISSING SUE
NEED A FORMULA TO COUNT IF A:A = MISSING AND B:B=JOE
RESULT WOULD BE 2
--
Dave Peterson