COUNTING FORMULA

[Guest]

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]

=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 here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html