View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Prickle
 
Posts: n/a
Default Help please - Countif with multiple criteria

I'm struggling to get to grips with array formula and don't have much time
left and so I am asking for your help to construct a fomula that will count
the cells in Range(A2:A500) that contain String_A whose corresponding cell
in Range(N2:N500) contains String_B

My grateful thanks in advance for any help