Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif criteria | Excel Discussion (Misc queries) | |||
sumif criteria | Excel Discussion (Misc queries) | |||
Criteria in SUMIF | Excel Worksheet Functions | |||
SUMIF with two criteria | Excel Discussion (Misc queries) | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions |