sumif criteria
Column A would be the salesperson
Column B would be the value of the proposal written
Column C would be the probability percentage.
I want an percentage average of C for the salesperson multipled by the value
of column b
"Bob Phillips" wrote:
Do you want to sum the numbers for a salesperson as multiplying a number by
a name is a problem?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Lori Hornick" wrote in message
...
One more....I keep striking out
If sales person in column a = ?
Multiply values for salesperson in column g X values for salesperson in
column i
--
Lori
|