View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mor
 
Posts: n/a
Default look up... i think

I have a column of potential leads, a column of salesreps assigned to those
leads, and a column of closings against those leads. I used COUNTIF to
report on the number of leads per sales rep. Now I would like to grab the
number of closings per rep. I can't find the right function to make it work.
I appreciate your help.

Thank you