Thread: sumif criteria
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default sumif criteria

What about G and I - just a distractor?
I keep striking out


You're striking out, and here I thought your question was serious.


--
Regards,
Tom Ogilvy

"Lori Hornick" wrote in message
...

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