Questions with a formula..

[Clay]

I'm using the formula:
=SUMPRODUCT(--(Honda!A7:Honda!A102=2),--(Honda!D7:Honda!D102="no"))
to display the amount of deals that are pending for a given finance manager
(in this case represented by the 2) . But I would also like to be able to
display the customer name which would be coming from the B column.

So for example, if there was 1 deal pending for manager 2, instead of the
cell displaying 1, it would say "smith" or whatever the customer's name was.
Also, can I display the names in a range of cells if there is more than 1
deal pending at a time.

Thanks in advance for the help!

 

[Pete_UK]

Put your list of names somewhere, eg in N1:N5. Then you can put this
formula in O1:

=SUMPRODUCT(--(Honda!A$7:A$102=2),--(Honda!D$7$102="no"),--(Honda!B
$7:B$102=N1))

This will give a count for the name in N1. Then copy the formula into
O2:O5 to get a count for the other names.

Hope this helps.

Pete