tailoreddigital
asked on
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
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sktneer, you know your excel. That's perfect. This has really helped my understanding of excel formulas.
Thanks again
Thanks again
You're welcome. Glad I was able to help. :)
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.