I have a Excel formula i need to adjust

tailoreddigital
tailoreddigital used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"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.

Author

Commented:
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.
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Please find the attached workbook and see if this is what you are trying to achieve.
PayTable-v2.xlsx

Author

Commented:
sktneer, you know your excel.   That's perfect.   This has really helped my understanding of excel formulas.

Thanks again
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome. Glad I was able to help. :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial