Melinda
04-23-2007, 08:34 AM
I would like to write a function for Column P that SUMS each employees payroll(from the payroll sheet using the SSN to match) from the start date indicated in the "Good Data" sheet and continuing for the number of payperiods(PPDs) indicated.
For example,
Christine Mills pay would start with 06/02/06 and continue for 13 Payperiod(PPDs). Hence her salary would be $2,402.60. However, Joe Black pay would start 12/17/06 and continue for 3 Payperiods(PPDs). Joe Black salary would equal $531.24
I have written several index, match and sumif functions but nothing is working. I have attached a sample worksheet. Thanks very, very much in advance:banghead:
For example,
Christine Mills pay would start with 06/02/06 and continue for 13 Payperiod(PPDs). Hence her salary would be $2,402.60. However, Joe Black pay would start 12/17/06 and continue for 3 Payperiods(PPDs). Joe Black salary would equal $531.24
I have written several index, match and sumif functions but nothing is working. I have attached a sample worksheet. Thanks very, very much in advance:banghead: