View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default countif or sumproduct ?

I have job titles in H2:H54 ( 10 various)
Some are occupied (names in B2:B34)
Some are vacant (B35:B54) nothing in B35:B54
I'd like a formula to count how many are occupied by title, and how many are
vacant by title.

Thanks,

Steve