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