View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMF in MN TMF in MN is offline
external usenet poster
 
Posts: 12
Default COUNTING FORMULA

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