SUMIF or IF Function?

[BradP]

I am creating a spredsheet to calculate our sales employees' bonuses.
Their bonus is a different % depending on what type of job it is and
who the sale person is.

Col A. - Job Name
Col B. - Type of Job (New, Renewal, Extra, Misc)
Col. C - Sales Personal ( Dave, Bob, Mark)
Col. D - Expenses
Col. E - Revenue
Col. F - Profit
Col. G - Profit %

I am trying to figure out the amount of each Type of Job per Sales
Person.

I was thinking the formual would be: IF Col B. = New and Col.C = Dave
than Sum Col. E .

Thank you for our help.

 

[Bob Phillips]

=SUMPRODCT(--(B2:B200="New"),--(C2:C200="Dave"),E2:E200)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[BradP]

I have never use the SUMPRODUCT, however I am get a error message when I
use that formula.

 

[Bob Phillips]

Sorry mis-spelt it

=SUMPRODUCT(--(B2:B200="New"),--(C2:C200="Dave"),E2:E200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[BradP]

Thank you.

I have just posted another question and look forward to your advice.