Citrusandsage
New Member
- Joined
- May 13, 2021
- Messages
- 12
- Office Version
- 365
Hi All,
So I was notified that our sales compensation plans will be based on a quarterly number not a YTD number. Therefore I need to be able to do a cumulative total but just by the quarter and then each quarter needs to start over again. I posted a picture of ideally how I would expect the formula to work, I cant figure out if I can do this by formula or if I am going to have to do this manually every quarter.
Each sheet will be different as the number of contracts someone sells will vary so would be great to be able to do a running total but only if XX cell = Q1 and so on. Any help would be appreciated
So I was notified that our sales compensation plans will be based on a quarterly number not a YTD number. Therefore I need to be able to do a cumulative total but just by the quarter and then each quarter needs to start over again. I posted a picture of ideally how I would expect the formula to work, I cant figure out if I can do this by formula or if I am going to have to do this manually every quarter.