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
Microsoft Excel
Last Comment
Subodh Tiwari (Neeraj)
8/22/2022 - Mon
SStory
"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.
tailoreddigital
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.
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.