Link to home
Start Free TrialLog in
Avatar of tailoreddigital
tailoreddigitalFlag for United States of America

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
Avatar of SStory
SStory
Flag of United States of America image

"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.
Avatar of 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.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
sktneer, you know your excel.   That's perfect.   This has really helped my understanding of excel formulas.

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