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

Microsoft Excel

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.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

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.