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.