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
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!