I'd like to multiply each row by the pay rate * hrs worked columns, and then get the sum of all

Options
edited 06/22/23

• ✭✭✭✭✭
Options

Hey @gruen

It looks like you're going to need to add a helper column, let's say it's called "Total Trip Pay", put in IT a formula:

=[Pay Rate]@row * [Hrs Worked/ Trips]@row

What I recommend is this:

Right click this formula & select "Make Column Formula" (that way it'll copy down regardless of how many entries you have.

If you do my recommendation above then you will NOT be able to total up the hours at the bottom of that "Total Trip Pay" column - but you can do it in the sheet summary on the right of the page with this formula:

=SUM([Total Trip Pay]:[Total Trip Pay])

If you ARE set on totaling the \$ at the bottom of the column, then just copy my first formula down the column until you hit the last calculation and then make the formula to add together everything in the "Total Trip Pay" column above it.

• ✭✭✭✭✭✭
Options

@gruen 's answer would be my preferred way to handle this, but it can be done without the helper column if necessary, although you would still need to relocate the sum of hours as mentioned above.

=AVGW([Pay Rate]:[Pay Rate], [HRS Worked/Trips]:[HRS Worked/Trips]) * SUM([HRS Worked/Trips]:[HRS Worked/Trips])

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!