software

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

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