SOLVED

New Contributor

# 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!

2 Replies
best response confirmed by JFreeman894 (New Contributor)
Solution

# Re: Excel Data Frequency Sum Help

See the attached demo workbook.

# Re: Excel Data Frequency Sum Help

What a hero! This is perfect. Thank you so much indeed!