Thread: Countif worksheet function frustrations
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Countif worksheet function frustrations
Hi,

Have you tried :
{=COUNT(IF(--(mhc.lease.no=F17)*(mhc.dept="DOTAG"),mhc.lease.no ))}


HTH
Carim

Reply With QuoteReply With Quote