sue_shee20
New Member
- Joined
- May 22, 2020
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hello,
I have a table of transactions that gets updated twice a day (7:00, 13:00). The 2nd update shows all the transactions from the 1st update along with any new transactions since the 1st update. I'd like to sum the latest Amounts using Date and Items field.
If there was only 1 update per day then a simple SUMIFS would work but I'm not sure how to make it sum the latest figures based on Date criteria of "5/21/2020" and Item criteria.
Any help is much appreciated.
Thank you
I have a table of transactions that gets updated twice a day (7:00, 13:00). The 2nd update shows all the transactions from the 1st update along with any new transactions since the 1st update. I'd like to sum the latest Amounts using Date and Items field.
If there was only 1 update per day then a simple SUMIFS would work but I'm not sure how to make it sum the latest figures based on Date criteria of "5/21/2020" and Item criteria.
Any help is much appreciated.
Thank you