The reason to use named ranges is to ensure that your Excel calculations are more understandable to yourself and others. For example, a formula that contains a named range such as =SUM(MonthlySales) gives a better indication of the overall calculation when compared to =SUM(C3:C14).