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

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.

@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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!