look up... i think

[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

 

[Biff]

Hi!

How do you denote a closing?

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

Biff