jakeman
Active Member
- Joined
- Apr 29, 2008
- Messages
- 325
- Office Version
- 365
- Platform
- Windows
I have been working on function that will create a unique list of values that sum the amounts for each value.
For example:
What I would like to do is create a unique list of Ctr Codes that would read as follows:
I'm stuck on how to combine filter function which filter on certain dates and the sum function which would add the Amount field together.
For example:
Ctr Code | Date | Amount |
001 | 1/2/23 | 55.00 |
002 | 1/15/23 | 12.75 |
001 | 1/21/23 | 38.22 |
002 | 1/23/23 | 100.01 |
What I would like to do is create a unique list of Ctr Codes that would read as follows:
Ctr Code | Amount |
001 | 93.22 |
002 | 112.76 |
I'm stuck on how to combine filter function which filter on certain dates and the sum function which would add the Amount field together.