Calculation of monthly installments

[Emilystorey]

I have a number of customers with multiple invoices that they want to
pay by installments. How can I create a simple ready reckoner that will
calculate the sum of each invoice installment that will be due each
month.

eg

Invoice 1 £100: Jan£33.33 Feb£33.33 Mar£33.33
Invoice 2 £300 Feb£100 Mar£100 Apr£100
Invoice 3 £900 Mar£300 Apr£300 May£300

Total per month

Jan £33.33
Feb £133.33
Mar £433.33
Apr £400.00
May £300.00

 

[Guest]

If monthly payments are their own column, can't you simply total the column?

Col A is Invoice number , Col B = Jan payments, Col C =Feb payments etc so
simply put =SUM(B:B) or SUM(B2:B200) in appropriate cell

If not, how is the data organised?

HTH