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