* Add up 1st, 2nd, 3rd and 4th instalment columns without using Named Ranges and not using Sum (∑)
* Use Create from Selection and create Named Ranges for 1st Instalment, 2nd Instalment, 3rd Instalment and 4th Instalment
* Use Apply Names, select your newly created Named Ranges (1st Instalment, 2nd Instalment, 3rd Instalment and 4th Instalment) to change the Total receipts column M
I FOLLOWED THE INSTRUCTIONS ABOVE BUT WHY AM I GETTING A SPILL AFTER APPLYING NAMES? MAYBE SOMEONE CAN HELP ME THANK YOU!