I have a Excel formula i need to adjust
I need to adjust the attached excel file's formula.
I need multiple Employee and Hours columns to contribute to the same Total Dollars.
How can i adjust this formula so that,
B C D E F G H I J K L M N
Employee | Hours | Employee | Hours | Employee | Hours | Employee | Hours | Employee | Hours | Employee | Hours | Total Dollars
So i need to calculate each employee hours (and some may be blank) then put that total in N.
B C D E F G H I J K L M N
chad | 1.5 | Dan | 4.2 | Eric | 5.2 | Employee | Hours | Employee | Hours | Employee | Hours | Total Dollars
i.e. N (Total Dollars) = chad pay rate x 1.5 + Dan pay rate x 4.2 + Eric pay rate x 5.2
PayTable.xlsx
I need multiple Employee and Hours columns to contribute to the same Total Dollars.
How can i adjust this formula so that,
B C D E F G H I J K L M N
Employee | Hours | Employee | Hours | Employee | Hours | Employee | Hours | Employee | Hours | Employee | Hours | Total Dollars
So i need to calculate each employee hours (and some may be blank) then put that total in N.
B C D E F G H I J K L M N
chad | 1.5 | Dan | 4.2 | Eric | 5.2 | Employee | Hours | Employee | Hours | Employee | Hours | Total Dollars
i.e. N (Total Dollars) = chad pay rate x 1.5 + Dan pay rate x 4.2 + Eric pay rate x 5.2
PayTable.xlsx
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"So i need to calculate each employee hours (and some may be blank) then put that total in N."
assuming row 2, for N2 just put in =C1+E1+G1+I1+K1+M1
Is that what you are looking for?
Looking at your attached spreadsheet looks nothing like what you mentioned above. Looking at it ,if I wanted one column with everyone's total $ in N, I'd go to N2 and put this formula in
=sum(G2:G20)
That would get the total from G2 to G20 (in case more employees are added) of everyone's totals.
assuming row 2, for N2 just put in =C1+E1+G1+I1+K1+M1
Is that what you are looking for?
Looking at your attached spreadsheet looks nothing like what you mentioned above. Looking at it ,if I wanted one column with everyone's total $ in N, I'd go to N2 and put this formula in
=sum(G2:G20)
That would get the total from G2 to G20 (in case more employees are added) of everyone's totals.
The employee's pay rate is being pulled from the Pay Table sheet, then being multiplied by the hours in the Hours column.
So employee in B pay rate is multiplied by Hours in C
employee in D pay rate is multiplied by hours in E
employee in F pay rate is multiplied by hours in G
employee in H pay rate is multiplied by hours in I
employee in J pay rate is multiplied by hours in K
employee in L pay rate is multiplied by hours in M
These totals are added and placed in the particular row in the N column.
So employee in B pay rate is multiplied by Hours in C
employee in D pay rate is multiplied by hours in E
employee in F pay rate is multiplied by hours in G
employee in H pay rate is multiplied by hours in I
employee in J pay rate is multiplied by hours in K
employee in L pay rate is multiplied by hours in M
These totals are added and placed in the particular row in the N column.
Please find the attached workbook and see if this is what you are trying to achieve.
PayTable-v2.xlsx
PayTable-v2.xlsx
Premium Content
You need an Expert Office subscription to comment.Start Free Trial