Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Assistance with formula in SumIf statement
Hello All,
Running Excel 2002 SP3, winxp sp2 operating system. I have an EmployeeName column, then 4 quarter headings, Q1 thru Q4. Under each quarter heading is 2 columns, "Date" and "Amt". The ranges for date and amount are Q1 = "D" and "E", Q2 = "F" and "G", ect. thru the Q4, then a total deducted column. The deductions for one employee can spread over two quarters. I am recording local taxes deducted from employees pay. It requires 4 columns to deduct the total amount for one employee. I would like to have an additional 4 columns setup M, N, O and P with a formula to determine how much was deducted in each quarter for each employee. Possible? Hope I have given adequate info. Thanks for any assistance. Bill |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Assistance with formula in SumIf statement
Correction to original post
Hello All, Running Excel 2002 SP3, winxp sp2 operating system. I have an EmployeeName column, then 4 deduction headings, Ded1 thru Ded4. Under each Deduction heading is 2 columns, "Date" and "Amt". The ranges for date and amount are Ded1 = "D" and "E", Ded2 = "F" and "G", ect. thru the Ded4, then a total deducted column. The deductions for one employee can spread over two quarters. I am recording local taxes deducted from employees pay. It requires 4 columns to deduct the total amount for one employee. I would like to have an additional 4 columns setup M, N, O and P with a formula to determine how much was deducted in each quarter for each employee. Possible? Hope I have given adequate info. Thanks for any assistance. Bill "bp" wrote in message ... Hello All, Running Excel 2002 SP3, winxp sp2 operating system. I have an EmployeeName column, then 4 quarter headings, Q1 thru Q4. Under each quarter heading is 2 columns, "Date" and "Amt". The ranges for date and amount are Q1 = "D" and "E", Q2 = "F" and "G", ect. thru the Q4, then a total deducted column. The deductions for one employee can spread over two quarters. I am recording local taxes deducted from employees pay. It requires 4 columns to deduct the total amount for one employee. I would like to have an additional 4 columns setup M, N, O and P with a formula to determine how much was deducted in each quarter for each employee. Possible? Hope I have given adequate info. Thanks for any assistance. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assistance with Formula | Excel Worksheet Functions | |||
Assistance with Formula | Excel Worksheet Functions | |||
Need assistance with a formula | Excel Worksheet Functions | |||
I need assistance setting up a "IF" statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |