I am trying to set up a spread sheet that will allow me to track salary costs. The question I have is that I have some cells that I need to track on a one year basis and others that are on a two year basis. An example would be if you have someone that is signed to a one year contract and others that are signed for two or more. Here is what I need:

COl A: Name COl B: Length Col C Salary
person a 2 35,000
person b 1 42,000
person c 2 36,000
person d 1 38,000

Total for 1 year[= cells]
total for 2 year[= cells]

I then have a two total cells that I would like to add up to the salary totals but the first would only add up to what the one year contracts are and the second one would add up to all of the contracts that are more 2 years or more.

Is this possible or is it just eaiser to just click through with out the formulas?

Thanks

Is there a way to do this with the formula options. I am not real framilar with the IF statments and can not get it to work

7/18/2006 6:01:04 PM

is this for a class or job?

7/18/2006 6:02:17 PM

more so a hobby,

7/18/2006 6:02:58 PM

use sumif()

[Edited on July 18, 2006 at 6:15 PM. Reason : =SUMIF(B1:B5,"=1",C1:C5), =SUMIF(B1:B5,"=1",C1:C5)+2*SUMIF(B1:B5,"=2",C1:C5)]

7/18/2006 6:10:57 PM

^ Thanks a lot that worked out for now. In the future I need to make it more complicated because I will have contracts that are over a 2 year period. But for right now it will work. Is there a way to set it up that the IF statement will work if your value is ">1" then (C2:C5) and so on....

Thanks again.

[Edited on July 18, 2006 at 6:34 PM. Reason : .]

[Edited on July 18, 2006 at 6:34 PM. Reason : .]

7/18/2006 6:33:56 PM

SUMPRODUCT(B1:B5,C1:C5) is the more general form of what you are doing

7/18/2006 6:37:59 PM