LauraEdson10
New Member
- Joined
- Apr 10, 2018
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
I have a Excel Document with two tabs. The first tab is a commission log where I calculate the amount of commission payable and the date it was then paid to the person.
I then have a second tab for the statistics so it counts how many orders were generated in a particular month (formula already done for this using COUNTIF) but then I wanted a formula where if a commission payment was made within October 2019 for example, it would add up the total values for that particular month. There could be one payment per month or several. The payment will always be made on 21st of each month.
For example, where payments in a column are 21/10/2019, look up the values in the next column and add them together.
21/10/2019 - £500
21/10/2019 - £250
21/11/2019 - £400
For October 2019, it would only then take 2 payments into consideration and therefore come back with a value of £750.
Hopefully this makes sense?
I then have a second tab for the statistics so it counts how many orders were generated in a particular month (formula already done for this using COUNTIF) but then I wanted a formula where if a commission payment was made within October 2019 for example, it would add up the total values for that particular month. There could be one payment per month or several. The payment will always be made on 21st of each month.
For example, where payments in a column are 21/10/2019, look up the values in the next column and add them together.
21/10/2019 - £500
21/10/2019 - £250
21/11/2019 - £400
For October 2019, it would only then take 2 payments into consideration and therefore come back with a value of £750.
Hopefully this makes sense?