Divide a value by the number of cells within the defined range.

Hello eveyone,

I'm trying to create a cashflow for every month for a particular job contract. For example lets say I have £200,000 in total but due to the nature of the work we will only be paid in installments over x amount of months. I could easily do this by picking the cell number and dividing it by lets say 4 months and copying the answer into 4 cells.

My question is, will I be able to use a formula, that allows myself or anyone else who edits the document, to simply select the cell value and simply drag it over x amount of cells and divide by the numbers of cells within the set range?

I hope I've explained this sufficiently but feel free to ask further questions.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.