SUMIF or IF Function?
 

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.


--
BradP
------------------------------------------------------------------------
BradP's Profile: http://www.excelforum.com/member.php...fo&userid=6255
View this thread: http://www.excelforum.com/showthread...hreadid=518977

SUMIF or IF Function?
 

=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" wrote in
message ...

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.


--
BradP
------------------------------------------------------------------------
BradP's Profile:
http://www.excelforum.com/member.php...fo&userid=6255
View this thread: http://www.excelforum.com/showthread...hreadid=518977

SUMIF or IF Function?
 

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


--
BradP
------------------------------------------------------------------------
BradP's Profile: http://www.excelforum.com/member.php...fo&userid=6255
View this thread: http://www.excelforum.com/showthread...hreadid=518977

SUMIF or IF Function?
 

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" wrote in
message ...

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


--
BradP
------------------------------------------------------------------------
BradP's Profile:
http://www.excelforum.com/member.php...fo&userid=6255
View this thread: http://www.excelforum.com/showthread...hreadid=518977

SUMIF or IF Function?
 

On Sat, 4 Mar 2006 07:21:39 -0600, BradP
wrote:


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


Two things to check.

1. There was a small typo in Bob's 'SumProduct'. If you copied and
pasted it rather than re-typed it, you would get an error.

2. Check the list seperator in your Control Panel Regional Settings
(Number) tab. Bob's suggestion used the comma, your may be a
semi-colon

HTH



Richard Buttrey
__

SUMIF or IF Function?
 

Thank you.

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


--
BradP
------------------------------------------------------------------------
BradP's Profile: http://www.excelforum.com/member.php...fo&userid=6255
View this thread: http://www.excelforum.com/showthread...hreadid=518977