# 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
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.

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.