.. . . and get the sum?

=SUMPRODUCT(G1:G100,I1:I100,--(A1:A100="?"))

--
Regards,
Tom Ogilvy


"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