TheOneTrueScotsman
New Member
- Joined
- Mar 21, 2021
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
I've got a sheet that's essentially generating my W2 based on entering the values on my check stub. I've also got rows along the bottom that extrapolate my earnings at the end of the year based on the average of all my paychecks for the year. I know that I need to subtract fixed amounts such as bonuses and expense reimbursements from the averages as they'll skew the extrapolations heavily, but I don't know how to tell Excel to do this.
What I need:
A way to tell Excel to search for values in my "reimbursements" column and subtract them from the corresponding entry in the "gross" column before averaging.
What I need:
A way to tell Excel to search for values in my "reimbursements" column and subtract them from the corresponding entry in the "gross" column before averaging.