look up... i think

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi!

How do you denote a closing?

=SUMPRODUCT(--(column of salesreps=salesreps_name),--(column of closings=How
do you denote a closing))

Biff
 
Back
Top