|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 4th, 2006, 12:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
March 4th, 2006, 01:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
March 4th, 2006, 01:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
March 4th, 2006, 01:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#5
March 4th, 2006, 01:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 __
|
|
#6
March 4th, 2006, 01:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to nest functions with SUMIF function in excel | Bobito | Worksheet Functions | 1 | November 20th, 2005 06:31 PM |
| How do I use the TODAY function with the SUMIF function? | Lisa B. | Worksheet Functions | 2 | September 30th, 2005 08:51 PM |
| SUMIF function with 2 conditions | rlandlin | Worksheet Functions | 4 | September 28th, 2005 05:50 PM |
| SUMIF() with AND() function?? | Ann Scharpf | Worksheet Functions | 6 | June 21st, 2004 06:21 PM |
| Sumif function | Dee | Worksheet Functions | 1 | December 4th, 2003 03:48 PM |
Linear Mode
