View Single Post
  #1   Report Post  
Belinda
 
Posts: n/a
Default Counting text criteria

I have two columns Column A contains contract numbers, i.e. s4802,
s5601--column b contains status words i.e. pending, approved, withdrawn. I
need a formula that will provide a count of each status by contact.