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

look up... i think
 

Hi!

How do you denote a closing?

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

Biff

"mor" wrote in message
...
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