Forum Discussion
Excel Data Frequency Sum Help
*UPDATED* Hi there, I wonder if anyone is savvy enough to help me as I am struggling with the correct sum to use in excel.
I have certain payments, and frequencies between certain dates that I need calculating.
| Action | Amount | Frequency | Start Date | End Date | Total to date |
| Regular | £500.00 | Monthly | 01/01/2023 | 01/04/2023 | £2,000 |
Simple example, If I pay £500, once a month, from 01/01/2023 to 01/04/2023, can I calculate the total in a cell? Using obvious maths, the answer is £2,000 but I cannot find the right sum 😞
I have lists that select the frequency which include:
Annual
Bi-Annual (every other year)
Bi-Monthly (every other month)
Monthly
Quarterly (every 3 months)
Single
Can anyone help? It's a tricky one!
If you really want a challenge, sometimes there is no end date as the payment is still current. Is there a sum to equal up to todays date? Thank you in advance!
See the attached demo workbook.
2 Replies
See the attached demo workbook.
- What a hero! This is perfect. Thank you so much indeed!
