sumif criteria
 

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

sumif criteria
 

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

sumif criteria
 

.. . . 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

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

sumif criteria
 

=sumproduct(--(A1:A100="Salesperson"),B1:B100,C1:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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

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

sumif criteria
 

My question is not clear. Let me try again:

Salesperson Proposal Value Probability
BW 15,000 50%
JP 5,000 10%
BW 10,000 10%
RB 20,000 50%
BW 5,000 10%

I'm looking for a formula that will give me the average value based on the
probability ratio by salesperson. Average probability ratio for BW is 23%
multiplied by the proposal dollar value would equal $6900.

"Bob Phillips" wrote:

=sumproduct(--(A1:A100="Salesperson"),B1:B100,C1:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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

sumif criteria
 

I get a slightly different answer, because the average is 23.33333333% not
23%.

=AVERAGE(IF(A2:A20="BW",C2:C20))*SUM(IF(A2:A20="BW ",B2:B20))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lori Hornick" wrote in message
...
My question is not clear. Let me try again:

Salesperson Proposal Value Probability
BW 15,000 50%
JP 5,000 10%
BW 10,000 10%
RB 20,000 50%
BW 5,000 10%

I'm looking for a formula that will give me the average value based on the
probability ratio by salesperson. Average probability ratio for BW is 23%
multiplied by the proposal dollar value would equal $6900.

"Bob Phillips" wrote:

=sumproduct(--(A1:A100="Salesperson"),B1:B100,C1:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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

sumif criteria
 

=Sumif(A1:A100,"BW",B1:B100)*(sumif(A1:A100,"BW",C 1:C100)/Countif(A1:A100,"B
W"))

--
Regards,
Tom Ogilvy

"Lori Hornick" wrote in message
...
My question is not clear. Let me try again:

Salesperson Proposal Value Probability
BW 15,000 50%
JP 5,000 10%
BW 10,000 10%
RB 20,000 50%
BW 5,000 10%

I'm looking for a formula that will give me the average value based on the
probability ratio by salesperson. Average probability ratio for BW is 23%
multiplied by the proposal dollar value would equal $6900.

"Bob Phillips" wrote:

=sumproduct(--(A1:A100="Salesperson"),B1:B100,C1:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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