WHY IT COMES OUT AS SPILL WHEN I APPLY NAMES? | Coursera Community

WHY IT COMES OUT AS SPILL WHEN I APPLY NAMES?


Badge +1

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

 

           

0 replies

Be the first to reply!

Reply